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
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
Can you explain cognos planning?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
Explain what is the difference between microstrategy and cognos reporting tool?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
What are the advantages of cognos?
What is difference between page break and section report?
What is main difference mapplets and mapping?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
What are all the advantages of Cognos?
What is the complex report you faced in real time?
How the Bursting happens in same report and how to Print the bursting Report?