Applying dimension security in a multi-hierarchy dimension -
08-16-2006
, 12:52 PM
I have this multi-hierarchy dimension that, when I try to set security
in its different hierarchies, it all gets mixed up when I test it.
I tested several scenarios, like using one different role for every
hierarchy, using one role to set security in two hierarchies, enabling
and unenabling the visual totals option, etc. In all cases, the result
is not what I expected.
I want to set some dimension security at parent levels in every
hierarchy, and also set the totals visible.
Has anybody ever tried to do this or now how to achive it?
Thanks,
Joren |