Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 9042 Views
- Accenture, HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / sandeep8000861
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 |
Post New Answer View All Answers
What is the difference between group and associare?
Cleared COG-112 with 100% score today. What next certification should i go for?
What is difference between informatica power mart and power center?
What r the names of the reports that you prepared?
What is cognos reporting tool?
What is looping and how to avoid it in framework manager?
Can you define pivot?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What is main advantage datawarehousing over oracle?
Can you define cognos decision stream?
How we check the errors before running the report?
What do you understand by the term 'dynamic cube'?
What you mean by drill across and what is the difference between drill through, drill across?
How to test a cube?
