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
- 9334 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 |
..Architectural difference between cognos reportnet and cognos8?
what is catalog and types of catalogs in cagnos and which is better?
Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com
what is sdibling function tell me the some functions
-----------------What is Singleton?
1 Answers BoA, Cap Gemini, TCS,
Where do you set security levels for users in reports?
how to explain health care project and which reports we can create in health care doain?
This question is asking in many interviews,,,,, What is your challenging task in report studio? anybody pls tell me some 2 or 3 challenging tasks,,,,
What is Cognos Mashup Services .what is the use of Cognos Mashup Services and where to use.
what r the filters in fwm and report studio
what is difference btw summary filter and detail filter, plz explain with example
10 Answers IBM, TCS,
What is RenderVariable?
Teradata 
