Very Computer

> Hi, I apologize if this is a real basic question, I'm new to Analysis
> Services and OLAP in general.

> I have created a cube which contains

>            Measure - revenue and gross profit
>            Dimensions - time, revenue type and company name

> Against the company name dimension I want the ability to give more
> information (not necessarily in a dimension) such as city, state, etc.
>  Ideally I would like the user to be able to choose what other fields
> they see when they use the company dimension (I'm using excel
> pivottables).   I tried putting each information field into a virtual
> dimension but the pivottable tries to group on each dimension.  I just
> want to see

>                                                 2003    2002   TOTAL
> PAULS COMPANY       TAMPA    FL    33647        25,000  12,000 27,000

> ^^^ MY DIMENSION ^^^  ^^ OTHER INFORMATION ^^

> Anyway of doing it?  
> Thanks

> Look at member properties , if you make these details an attribute of
> your dimension member on your dim table you can make them member
> properties in AS.

> Mark

> Good suggestion. However, it also depends on the olap browser used by the
> end user. Office, AKAIK, will not show the properties. Microsoft Data
> Analyzer shows them.

> > Look at member properties , if you make these details an attribute of
> > your dimension member on your dim table you can make them member
> > properties in AS.

> > Mark

> > > Hi, I apologize if this is a real basic question, I'm new to Analysis
> > > Services and OLAP in general.

> > > I have created a cube which contains

> > >            Measure - revenue and gross profit
> > >            Dimensions - time, revenue type and company name

> > > Against the company name dimension I want the ability to give more
> > > information (not necessarily in a dimension) such as city, state, etc.
> > >  Ideally I would like the user to be able to choose what other fields
> > > they see when they use the company dimension (I'm using excel
> > > pivottables).   I tried putting each information field into a virtual
> > > dimension but the pivottable tries to group on each dimension.  I just
> > > want to see

> > >                                                 2003    2002   TOTAL
> > > PAULS COMPANY       TAMPA    FL    33647        25,000  12,000 27,000

> > > ^^^ MY DIMENSION ^^^  ^^ OTHER INFORMATION ^^

> > > Anyway of doing it?
> > > Thanks