Export (0) Print
Expand All

Custom Dimension Security Dialog Box

SQL Server 2000

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)

Options

The following options are displayed for all tabs.

Permission

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.

Description

Enter the description of the custom rule.

Restore Defaults

Discards any changes you have made to a cube role.

OK

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).

See Also

Custom Rules in Dimension Security

Show:
© 2014 Microsoft