I'm struggling with implementing a cube role.
Lets say I've got 2 dimensions, the measures dimension and a dimension for Area. Area drills down into North, South, East and West as an example. Within the measures dimension there is, among others, a measure called "forecast".
The role needs to allow all users access to all members within the Area dimension, the users are allowed to view all measures except for the forecasts measure. You can only see the forecasts within your own area.
I find it easy to implement roles based upon one dimension, eg limiting a specific users access to members within a dimension, and its also easy to limit the visibility of a measure, but how do you combine dimensions into one role ?? Will I have to implement some custom MDX to achieve this, as I cant seem to enable this feature via the roles interface.
Any help would be appreciated, hope your having a great day.