Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

How to generate cubes in cognos?

968


what is the difference between list report and crosstab report?

1181


Can you define fan trap?

1265


What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4580


Can you define a query subject?

1012


How to do Performence Tunning in Cognos Reports?

2475


How create measures and dimensions?

1076


How to create a cube in Transformer? What is the process? Please mention process thank u

1762


Which lifecycle we will use for reporting?

971


What is defined as catalog and types of catalogs in Cognos?

1134


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2246


how u will determine the performence tune will occur either in report or system

2134


what is model and say about process how to create model and how to test model?

1059


Can you define cognos decision stream?

990


what are the special features in cognos reportnet?

1059