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
- 9025 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
Define catalog in cognos and write its various types?
What DB View and Bus View?
Define metrics studio?
What do you understand by the term 'dynamic cube'?
What are the steps to import the two data sources in framework manager?
Can you define metrics designer?
What is the use of powerhouse?
What do you understand by the term 'model durability'?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
Why need staging area database for dwh?
What is set to be cardinality?
hi friends pls forward impropmtu interview question
how to create cubes in transformer ?
What are the different types of reports present in cognos?
How is cognos model organization works?
