Excel 2007, SSAS2005, Calculated Member Format Does Not Pull Into Sheet   

All:

I have designed a cube wherein I have several calculated members used as 
measures where I set the format to be currency.  Although the formats from 
all other dimensions and measures gets pulled through to the Excel pivot 
table, the calculated measure formats do not.  I haven't found a bug 
report - is anyone else seeing this kind of behavior?

Dwight

date: Fri, 20 Jun 2008 11:28:39 -0400   author:   Dwight Specht dspecht[junkfilter-replace with @ sign]ibisinc.com

Re: Excel 2007, SSAS2005, Calculated Member Format Does Not Pull Into Sheet   

Okay, found out this is not an Excel issue but an issue with how I setup the 
calculated member.  When you pick the Currency format, you also have to 
specify the Language.  However, Language is not exposed via the form, so you 
have to switch to script view, add the line LANGUAGE = 1033, and voila, the 
Currency format now comes through.

Dwight


"Dwight Specht" <dspecht[junkfilter-replace with @ sign]ibisinc.com> wrote 
in message news:18B0E7DD-B0A0-46B2-8F72-F916CA5AA073@microsoft.com...
> All:
>
> I have designed a cube wherein I have several calculated members used as 
> measures where I set the format to be currency.  Although the formats from 
> all other dimensions and measures gets pulled through to the Excel pivot 
> table, the calculated measure formats do not.  I haven't found a bug 
> report - is anyone else seeing this kind of behavior?
>
> Dwight
>

date: Tue, 24 Jun 2008 10:34:51 -0400   author:   Dwight Specht dspecht[junkfilter-replace with @ sign]ibisinc.com