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
- 8000 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 |
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
In Drill through, Reports are executing successfully when rename & run the created reports? Pls tel me the reason?
what are typees of dimensions
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
in which scenario we go for views in cognos or oracle?
what is power prompt in cognos ep7series?what is the use of this?
how you provide security to reports? How you provide security to packages ?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
3 Answers TCS, Thomson Reuters,
If you got any problems while developing the reports, then what will you do? How will you debug the problems? This question isasking in many interviews,,,, pls help me,,,
what is the generated prompt,how can i use?
What do you mean by query studio?
Explain about scorecarding?
Teradata 
