How to group dimensions

View previous topic View next topic Go down

How to group dimensions

Post  mohsinazizz on Wed Feb 08, 2012 7:24 pm

I have searched a lot but couldn't find how to show a set of relevant dimesions as one group/folder.

Basically what we have got is about 50/60 dimensions, which makes it very hard for end users to find a particular dimension. What i looking for is some way to show these dimensions as a group (i.e. folder like structure). Is it possible?

End users use Excel to view the cube. we are using SSAS 2008 to build the cube.

Any help or idea would be highly appreciated.

Thanks,
Mohsin

mohsinazizz

Posts : 5
Join date : 2012-02-08

View user profile

Back to top Go down

Re: How to group dimensions

Post  Mike Honey on Mon Feb 13, 2012 8:58 pm

Hi Moshin,

The best solution I've come up with is adding a prefix to the Cube Dimension Name, e.g "Customers" becomes "Sales - Customers". As Excel automatically sorts the Dimensions, the prefix has a grouping effect.

Good luck!
Mike

avatar
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

View user profile http://www.mangasolutions.com

Back to top Go down

Re: How to group dimensions

Post  mohsinazizz on Sun Feb 19, 2012 6:12 pm

Thanks Mike, what I understand from this is that there is no "REAL" dimension grouping option available to us in SSAS.

mohsinazizz

Posts : 5
Join date : 2012-02-08

View user profile

Back to top Go down

Re: How to group dimensions

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum