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
Explain what is the difference between microstrategy and cognos reporting tool?
how to create measures and dimensions?
What is set to be Cognos configuration?
How do you Parametermap variables in Quiries?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
what is the difference between filter and condition?
What are various types of gateways in cognos?
how to merge 2 crosstabs thans
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
What is main difference mapplets and mapping?
What are the steps to import the two data sources in framework manager?
What is a dimension?
---------------Describe OLAP Reporting and RDBMS Reporting?
What is meant by Reportstudio shortcut?
What are shortcuts? Where it can be used? What are the advantages?