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
- 9177 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 junk dimension contains?
What is the size of database for you project?
How security is concerned with Reportnet? Explain its implementing steps.
explain how to create powerplay reports?
please please give me some banking calculations in framework manager.
-----------Diff b/w OLAP and RDBMS?
How to a create header dynamically in a crosstab report in cognos 8.1?
What do you understand by user class in cognos?
What are all the different types of prompt in cognos?
What is the use of powerhouse?
What is difference between primary key and unique key constraints?
Can you define folder?
What are the themes in a data warehouse?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
What is a dimension?
