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.
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
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
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
Can you define cognos decision stream?
What is difference between content store and content manager?
What are the roles defined by cognos platform?
Can you explain cognos planning?
What is the enterprise class platform architecture of cognos 8?
What are all the types of report?
------------ Diff b/w MemberCaption and MemberDescription?
What are slice and dice?
What is model?
What is the difference between drill through, drill across?
What do you understand by the term 'aggregate cache'?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
Write various indexes used in cognos?