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

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?

2107


Actually we have 500 users when they run the report display the flage image related country user? How its possible?

2068


What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

1215


Can you explain cognos planning?

1126


how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance

2145


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

1141


what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

2131


What are the advantages of cognos?

1031


What is difference between page break and section report?

1256


What is main difference mapplets and mapping?

1271


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

2511


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..

2270


What are all the advantages of Cognos?

1079


What is the complex report you faced in real time?

2232


How the Bursting happens in same report and how to Print the bursting Report?

1918