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
- 8487 Views
- Accenture, HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / mohanakrishnak
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 |
Post New Answer View All Answers
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
What are the components of report net?
how u will design the report if the objects are available
What are cognos connection initial page components?
What is the difference between regular dimension and derminant?
What are initial page components of Cognos connection?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
Is it possible to join multiple Databases in a Catalog?
What is difference between primary key and unique key constraints?
Can you define cognos impromptu?
What is a Query Subject?
What are all the types of indexes in Cognos?
--------------Diff b/w ODS and OLAP?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
What is Fullouterjoin?
