I have set formatting of a calculated member in a cube to 'percent'.
When I view the calculated member in an office 2003 pivot table, it
does not apply the formatting defined in the cube. Is there a way I can

get measures to display the format defined in the cube in a pivot
table?
Every time I have to change the format in Excel for these Fields, also
once these fields are removed from the data fields and placed back it
loses its format.

The same question was posted way back in 2004 but there was no answer
to this question and even i am facing the same problem

Excel 2003 doesn't support the server-defined format.
Excel 2007 does use it.
If you want to use Excel 2003, the only way to make it working is to
use the Excel Add-In for Analysis Services (see my post:
http://sqljunkies.com/WebLog/sqlbi/a...24/17686.aspx).

Marco Russo
http://www.sqljunkies.com/weblog/sqlbi
http://www.sqlbi.eu

Prabodh wrote: