148 IBM Cognos Dynamic Cubes
7.1 Overview of dimensional security
Dynamic Cubes dimensional security restricts the members in a hierarchy that users are
allowed to access. The hierarchy members that a user has access to is defined through
dynamic query expressions.
Restricted members are either those members explicitly denied or, when there are members
explicitly granted, those members that are
not explicitly granted.
With Dynamic Cubes, level-based ragged and unbalanced hierarchies in dynamic cubes are
converted into balanced, non-ragged hierarchies through the use of padding members. To
remain consistent with the manner in which hierarchies are presented, the application of
dimensional security to a level-based hierarchy retains the non-r ...