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
- 9208 Views
- Accenture, HCL, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / prathik
we can use conditional blocks.Create a value prompt with a radio buttons.So that user can select based on his requirement.
| Is This Answer Correct ? | 0 Yes | 5 No |
How to generate cubes in cognos?
difference between stored procedure and function?
Define query studio?
How to Create users in cognos Access Manager from 1) front end 2) back end
What is Render Variable? where u can use?
how can you create a report like if country=india then true if contry=spain then false?
Can i apply drill through on master detail relationship report?
2. What functional area you worked on.
what are the dimensions that you have in your current project?list them?
Hi, How the relations will be exists in DMR models if u have any idea please explain me
What is Cognos Powerhouse and what is it used for?
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
Teradata 
