SSAS Calculated Member's Currency Format Displayed in Excel 2007
Problem:
After creating a calculated member in your SSAS cube, you connect to the cube via Excel 2007 and drag the calculation into your Pivot table. However, although the Format is set to Currency in the cube , the calculation appears as an unformatted number in the Pivot table.
Solution:
Tags: excel