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

[Dwight Specht]

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

 

[Dwight Specht]

Okay, found the issue. The Language property is not exposed via the
interface and, when you chose the currency format, you need to also specify
language. So, you change to Script view, insert the line "Language = 1033;"
for US, and everything works fine.