Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

How to group dimensions

2 posters

Go down

How to group dimensions Empty How to group dimensions

Post  mohsinazizz 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

Back to top Go down

How to group dimensions Empty Re: How to group dimensions

Post  Mike Honey 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

Mike Honey
Mike Honey

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

http://www.mangasolutions.com

Back to top Go down

How to group dimensions Empty Re: How to group dimensions

Post  mohsinazizz 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

Back to top Go down

How to group dimensions Empty Re: How to group dimensions

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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