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

  • Thread starter Thread starter Dwight Specht
  • Start date Start date
D

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