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?