Databases Reference
In-Depth Information
Figure 19-24
The next step is to create the MDX expression in a single role that will define
dynamic security for all the users. Once again, you need the MDX function
username. Create a new role. Add all the users who need access to the cube
to the membership collection of the role. Once you have provided read ac-
cess to the cube and the dimensions, go to the Advanced tab of the Dimen-
sion Data pane. Select the dimension Location and hierarchy City. Enter the
following MDX expression for the Allowed set:
Filter (Location.City.City.members,
Instr (Location.City.currentmember.properties
Search WWH ::
Custom Search