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
- 9215 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 |
what r the names of the reports that u prepared???
9 Answers Covansys, IBM, Wipro,
What is content store?
if u generate a cube r pakage then its published we open in cc its ask every time for username &pass word?what we do?the pak r cube was not asking the password? what we do for this problem?pls ans me.............
Hi,please suggest me how to creat username while creating a report.
What are the message flows?
What is the difference between filter & Condition?
----------------------What are the User Securities?
when can i use the STAR Schema and SNOWFLAKE Scgena
what is Governor settings in cagnos?
Hey Techies, Could you please tell me about query processing? and what is database only and what is Limited locale? brief plz..
1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?
how can you create a report like if country=india then true if contry=spain then false?
Teradata 
