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.
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
How to generate cubes in cognos?
what is the difference between list report and crosstab report?
Can you define fan trap?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
Can you define a query subject?
How to do Performence Tunning in Cognos Reports?
How create measures and dimensions?
How to create a cube in Transformer? What is the process? Please mention process thank u
Which lifecycle we will use for reporting?
What is defined as catalog and types of catalogs in Cognos?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
how u will determine the performence tune will occur either in report or system
what is model and say about process how to create model and how to test model?
Can you define cognos decision stream?
what are the special features in cognos reportnet?