i created several calculated dimension members and don't understand why in
excel the calculated members can't be displayed under the dimension. anybody
can give me some hints? thanks a lot.

another question is, in [dimension].[all dimenstion], the calculated
dimension members shouldn't be counted, right? thanks again

What client tool are you using? This is a known restriction of Office 2000,
i.e. that it would only display calculated measures; not calculated members
in other dimensions.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"urgent" <urgent (AT) discussions (DOT) microsoft.com> wrote

i'm using Office XP. How can i solve the problem by seeing calculated
dimensions in Pivot table??? Thanks.

"Dave Wickert [MSFT]" wrote:

Hmmm.. then it should work. Have you used any other client tools, e.g. OWC,
Cube browser in AM, MDX Sample app, etc.? First task is to narrow it down
directly to Excel XP only.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"urgent" <urgent (AT) discussions (DOT) microsoft.com> wrote