Custom Dimension Security Dialog Box
Use this dialog box to create a custom rule for dimension security.
You can specify a range of dimension levels that are accessible to the role. Within this range, you can also specify which dimension members are accessible.
Important If you limit access to levels or members by using the Basic or Advanced tab, consider selecting Enable - Show visual totals in the Common tab. If instead you use the default setting for visual totals (that is, Disable - Do not show visual totals), security exposures might be created. These exposures allow end users in the role to deduce values for members to which they are denied access. For more information, see Example 4, Example 6, Example 8, and Example 9 in Custom Rules in Dimension Security.
This dialog box is displayed when, in the Dimensions tab of the Database Role dialog box or Cube Role dialog box, you select a custom rule, and then, in the Custom Settings column, click the edit (...) button.
The Custom Dimension Security dialog box has three tabs. For more information about the tabs, click a link in the following table.
|To do this||See|
|Define a custom rule by selecting levels from lists and members from a tree||Basic Tab (Custom Dimension Security Dialog Box)|
|Define a custom rule by supplying Multidimensional Expressions (MDX)
Specify a range of dimension levels that are accessible to the role, and, within this range, specify which dimension members are accessible
|Advanced Tab (Custom Dimension Security Dialog Box)|
|Specify options for visual totals and select a default member||Common Tab (Custom Dimension Security Dialog Box)|
The following options are displayed for all tabs.
View the permission to which the custom rule applies. This box is read-only.
Note If the custom rule applies to a read/write permission in a cube role, changes propagate to the database role of the same name.
Enter the description of the custom rule.
Discards any changes you have made to a cube role.
Click to close the dialog box. After you close the dialog box, save the custom rule by clicking OK in the Edit a Database Role dialog box or Edit a Cube Role dialog box (depending on whether you are working in a database role or cube role).