When connecting Excel 2010 to a SSAS 2008 R2 datasource, calculated fields(Standard Margin) do not display with the appropriate currency symbol. When I define the measures in the cube, I am setting the 'format string' property to the appropriate value.
There are three cases-
- Fixed measures marked as currency; they display correctly
- Calculated measures marked as percentages; they display correctly
- Calculated measures marked as currency; they display as simple decimal numbers.
This appears to specific to Excel. Management Studio displays the cell data correctly.
Is this a known issue? Alternately, can anyone reproduce this issue?