Report Portal

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:  

Read more...

Tags: excel

 

2007-2015 VidasSoft Systems Inc.