define access to dimension bottom levels at multi-level -
05-21-2004
, 04:05 AM
Hello,
I have a basic question in AS. I have a product dimension with 5
levels. I would like to define a role that has access to all bottom
levels of 4 (ie last-1) of products except for a particular member of
level 2, for which the bottom level will be level 5 (ie all) .
I have set all the bottom levels to level 4 in the manage roles in the
advanced tab (bottom level), but it seems to require some clever MDX
to define the bottom levels.
Hope this makes sense.
Thx |