sql server data warehouse: 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?

Well, it's been over a month with no response, so I'll ask the question
another way:

I know this can be accomplished programmatically - You can turn on the
option through code to allow the formatting that is defined for a measure to
be applied in an Excel pivot table when you are viewing measures.

The problem is that I want non-power users to query cubes and view measures
with minimal knowledge of Excel or interaction such that they would not have
to re-apply formatting of percentages, etc.

I want the format for the measures that I have defined in the cube to be
retained in the Excel pivot table, and I want users to be able to create new
queries via the pivot table and view the measures with the formats that are
pre-defined in the cube.

The question is: is there a non-programmatic way to allow the format that is
defined in the cube to be retained when new OLAP queries are defined by users
where the user does not have to apply a format to the measure?


[quoted text, click to view]