In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.
Answers were Sorted based on User's Feedback
This required identifying the location of the logged in user first which needs to be derived from account.personalInfo.userName key unless the location data is readily/explicitly available on the DWH table.
Once we have this info, conditionally rendering the format (just format?? not the amount too??) using a string conditional variable or any other approach.
See: http://www.ibm.com/developerworks/data/library/cognos/modeling/security/page544.html
Is This Answer Correct ? | 3 Yes | 1 No |
The Best Way is to create a table based on Current day conversion values and use this table for calculation with the "Sale Amount".
This table contains locale as one columns and conversion amount as another columns.
Locale Rate
------ ----
Usa 64
Uk 85
Rupee 1
China 3 ...etc
Use the account.Userlocale session parameter to get the user locale and multiply with 'Rate' column amount.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / prathik
we can use conditional blocks.Create a value prompt with a radio buttons.So that user can select based on his requirement.
Is This Answer Correct ? | 0 Yes | 5 No |
What is the difference between static and dynamic conditions?
can anybody send me interview questions with answers on IBM cognos-FM and Report studio. My mail ID is: cskcognos@gmail.com
what is degenerate key in oracle ?whare do we use it?
I want to run one page with filter and another page without filter, what is process?
what is dash board?
How do we create row level security in cognos8?
hi guys, i think this would be a simple question but i was asked. what is total time taken to develop a report from getting requirement document from the client? dont reply as it depends,i am expecting something else.
7. What is performance tuning?
-------------------What is Deployment?
-------------How to create a PortalTab?
What is the complex report you faced in real time?
what is report view?