Hi guys

I have a dimension which has only 2 levels, All and location. This flat dimension is causing some problems in that we would like to setup groups of locations in such a way that different users will have there own groups. The problem is that user A may want locations X,Y and Z but user B may want locations W,X and Y. So creating the dimension becomes problematic. We would like these custom groupings to be available to all users as a dimension in Excel using PTS

So ideally it would be a dim with a custom level then the locations, where locations could be repeated across custom nodes.

Any ideas how I could go about this

Thank

Naz

Couple ways you could do this, easiest way would be to create views on the
underlying tables and name them appropriately that would only get back the
locations that the particular users wanted. Use those views as dims in the
cube. This way you could still offer the "all locations" as a dim and the
views could be used by themselves as dims if the user so chose. As you have
some locations that can reside in multiple groups, a star or snowflake
schema might not be the optimal solution, someone may disagree with that.

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
"Naz" <anonymous (AT) discussions (DOT) microsoft.com> wrote

locations in such a way that different users will have there own groups. The
problem is that user A may want locations X,Y and Z but user B may want
locations W,X and Y. So creating the dimension becomes problematic. We would
like these custom groupings to be available to all users as a dimension in
Excel using PTS.