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
- 8001 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
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
What is called Cognos powerplay?
What is the advantage of using shortcuts?
how to explain health care project and which reports we can create in health care doain?
-------------What is Coditional Prompting?
What is difference between data mart and data warehouse?
how u will determine the performence tune will occur either in report or system
what is online view?
--------------Explain Table of contents?
what are the errors faced while bursting the reports and how to solve those errors?
What are the considerations regarding performance kept in mind while setting up cognos?
Can you define transformer?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What are the batches and it’s details? What do you understand by the cognos?
