Continuing with the SampleSchema TBI_PANPROVIDER example from Defining Level Security. A user with the TBI_PANPROVIDER role is restricted from drill down access to levels below Product Department for the Product dimension’s Products hierarchy. This example demonstrates how to restrict access to the [Food] and [Non-Consumable] members of the Product Family level for the TBI_PANPROVIDER role.
- Select the TBI_PANPROVIDER role.
- In the Permissions box, expand the permissions for the Sales and Employees cube and for the Product dimension.
- Click the Products hierarchy.
- Select Top Level for the Product Family Level Name, and click Create. The Member Security Dialog box appears.
- Select [Food] and [Non-Consumable] in the Members matching filter box, and click the right arrow to move them to the Access to these members is box.
-
Click Deny.
-
Click OK.
The TBI_PANPROVIDER role can only access [Product].[Drink] and its children. The Clear button for the Product Family level is now enabled in the Schema Element Properties View.