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
- 9002 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
Can you define bitmap index?
what is catalog and types of catalogs in cagnos and which is better?
Define datastores in cognos?
Define cognos report net?
What is the difference between a cascading report and drill through the report?
Define olap designer?
What is model filter?
How can we create a dynamic column name in cognos?
------------ Diff b/w MemberCaption and MemberDescription?
What do you mean by drill through report?
Cleared COG-112 with 100% score today. What next certification should i go for?
What is the difference between low affinity and high affinity connections?
Can you define confirmed dimension?
what is the difference between list report and crosstab report?
How to join multiple db in catalog?
