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

Explain what is the difference between microstrategy and cognos reporting tool?

1076


how to create measures and dimensions?

1123


What is set to be Cognos configuration?

1029


How do you Parametermap variables in Quiries?

2267


I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

2283


what is the difference between filter and condition?

1068


What are various types of gateways in cognos?

1063


how to merge 2 crosstabs thans

2643


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 ?)

2445


What is main difference mapplets and mapping?

1201


What are the steps to import the two data sources in framework manager?

1048


What is a dimension?

1035


---------------Describe OLAP Reporting and RDBMS Reporting?

2105


What is meant by Reportstudio shortcut?

2188


What are shortcuts? Where it can be used? What are the advantages?

1074