In one of my report i have one data item sales_amount. If this report is run by

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.

Question Posted / kapil yalawar

4 Answers
9175 Views
Accenture, HCL, IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In one of my report i have one data item sales_amount. If this report is run by one user from india ..

Answer / 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

In one of my report i have one data item sales_amount. If this report is run by one user from india ..

Answer / krishna

Use currency conversion filter dynamically

Is This Answer Correct ?

1 Yes

0 No

In one of my report i have one data item sales_amount. If this report is run by one user from india ..

Answer / mohanakrishnak

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

In one of my report i have one data item sales_amount. If this report is run by one user from india ..

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

Post New Answer