In one of my cost cubes I have a measure called - Amount and I also
have a dimension in the cube called Currency.

For a given record if the cost is 8900 US Dollar or 8200 Euros the
data appears in the cube as

Amount = 8900 Currency = USD
Amount = 8200 Currency = EUR

Our users wants the data for the amount to be displayed as follows:


8900 USD
8200 EUR

how can I display the data in this format. In Excel I know I can set
the format for the amount field to special to display USD ot EUR how
can I make this dynamic so the amount value is displayed as 8900 USD or
8200 EUR.

Thanks
Karen

Presuming that your currency is a dimension, you could always create a
calculated member based on the original measure (amount) and use a iif
statement to determine if the currency dimension member of that cell is USD
or EUR and show the appropriate format.

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



"KarenM" <karenmiddleol (AT) yahoo (DOT) com> wrote