How to create a custom rule for cell security

To create a custom rule for cell security

1. In the Analysis Manager tree pane, right-click the cube associated with the cube role in which you want to create a custom rule, and then click Manage Roles.
   
   
2. In Cube Role Manager, select the cube role in which you want to create a custom rule, and then click Edit. If the cube role does not yet exist, you must create it before performing this procedure. For more information, see Creating Cube Roles.
   
   
3. In the Cube Role dialog box, click the Cells tab.
   
   
4. In the Cell security policy box, select Advanced.
   
   
5. In the row displaying the permission for which you want to create a custom rule, in the Rule column, select Custom. For information about permissions, see Cell Security.
   
   
6. In the same row, in the Custom Settings column, click the edit (...) button.
   
   
7. (Optional.) In the Cube Cell Security dialog box, in the Description box, type a description of the custom rule.
   
   
8. In the MDX box, type a Multidimensional Expressions (MDX) expression to allow or deny access to specific cube cells. Or, instead of typing, beside the box you can click the edit (...) button to access MDX Builder, where you can create the expression by using drag and drop techniques. For more information, see Custom Rules in Cell Security.
   
   
9. Click OK.
   
   
10. In the Cube Role dialog box, click OK.

See Also

Defining Custom Rules for Cell Security