COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Analysis Studio => Topic started by: blom0344 on 06 Jul 2009 10:46:19 AM

Title: displayal of dollar instead of euro currency sign
Post by: blom0344 on 06 Jul 2009 10:46:19 AM
I have a number of measures from a traditional cube with formatting set to euro currency sign. However , analysis studio displays dollars as currency. Regional settings are in euro. Is there any other place to influence the currency displayed?
Title: Re: displayal of dollar instead of euro currency sign
Post by: DustPanMan on 06 Jul 2009 11:16:46 AM
Blom,

The only other thing you may want to try is importing your Cube into Framework manager and changing it there.  What version of Cognos 8 are you on?

Best regards,

Dustin
Title: Re: displayal of dollar instead of euro currency sign
Post by: blom0344 on 06 Jul 2009 02:49:26 PM
The KB has the following article:

"Setting the default currency symbol for PowerCubes"

which indicates:

Quote
In Cognos 8 there is no concept of a "system default" locale, so cubes without a currency table default to using dollar signs. Cubes that show pounds in PowerPlay show dollar signs in Analysis Studio.

1. In the File menu, select Currency table, and click OK.
2. For each currency measure, right-click on the measure and select Allow currency conversion.

So,I'll try the currency table option.

note:

Seems to work out pretty well , but adding the currency itself as dimension in Analysis Studio..
Title: Re: displayal of dollar instead of euro currency sign
Post by: johnpenna on 13 Aug 2009 06:57:00 AM
Theres a setting in the config folder in a file called qfs_config.xml

Search for  "fallbackCurrency". Just change to what you need.

This works for ALL Analysis Studio cubes in C8.
Title: Re: displayal of dollar instead of euro currency sign
Post by: blom0344 on 14 Aug 2009 02:21:23 PM
Thank you John, will check it out..