Analysis Services
Defining Custom Rules for Dimension Security
A custom rule is the most flexible type of rule for controlling access to dimension members by users in a role. In a custom rule, you can allow and deny access to specific dimension levels and members. You can also control visual totals and select a default member.
You can create a custom rule for dimension security in a database role or in a cube role. Custom rules in a cube role override custom rules in the database role of the same name.
To create a custom rule in a database role, use Database Role Manager, the Database Role dialog box, and the Custom Dimension Security dialog box.
To create a custom rule for dimension security in a database role