Re: problem to display calculated dimension members in pivot table

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@xxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3B41F422-528D-4E0F-8886-A8CD44261454@xxxxxxxxxxxxxxxx
> i'm using Office XP. How can i solve the problem by seeing calculated
> dimensions in Pivot table??? Thanks.
>
> "Dave Wickert [MSFT]" wrote:
>
> > 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@xxxxxxxxxxxxxxxxxxxx
> > 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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:37F4E0E3-96DC-4510-9C3C-A82AF4708DE1@xxxxxxxxxxxxxxxx
> > > 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
> > >
> >
> >
> >


.

Relevant Pages

  • Re: How to create a dimesnion for a range of values
    ... SQL BI Product Unit (Analysis Services) ... > Dimension Name: Quantity Range ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Same Dimension tables?
    ... Analysis Services loads from a view as easily as it does from a base table. ... SQL BI Product Unit ... > I have a cube that has 2 dimension tables that are identical, ... Is there a way I can share the dimension data without having the ...
    (microsoft.public.sqlserver.olap)
  • Re: How do I do this!!
    ... "SQL Server Developers Guide to OLAP with Analysis Services" which is good ... > property and create a virtual dimension off of it. ... >> I have a customer dimension which stores the customers birth date. ... >> age range. ...
    (microsoft.public.sqlserver.olap)
  • Re: Load and Concurrency
    ... If your dimension is big you could run into performance issues. ... > If you find that you can't live with the manability of Analysis Manager at ... Dynamic security has a single role, ... > administrative steps over and beyond what Analysis Services provides. ...
    (microsoft.public.sqlserver.olap)
  • RE: Key Uniqueness Code
    ... If dimension key for the dimension in question is not unique, as a result, ... Analysis Services dimension structure. ... You may want to consider properly normalize your underlying relational ...
    (microsoft.public.sqlserver.olap)