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
- 8996 Views
- Accenture, HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / sandeep8000861
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 |
Post New Answer View All Answers
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
What are the different types of important services used in cognos?
Can you define cognos powerplay?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
What is an olap designer?
How can we create a dynamic column name in cognos?
what are the features in cognos8ui
What do you mean by query studio?
What is the difference between static and dynamic conditions?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
What are the advantages of cognos?
What are the message flows?
How do we drill through from a powerplay cube to reportnet?\
WHAT ARE THE DISTNICT VARIABLES?
4. How many dimensions did you use in your reports?
