Applying Cell-level Security to a Cube
Dimension-level security prevents the user from seeing certain members. Such security does not directly prevent viewing of cell values, but, clearly, if a member does not appear, the values for that member will not be visible either. In short, in most situations, dimension-level security is all you’ll ever need. In some situations, however, you might want reports to display all the members but block the values for some of the cells. When you need to secure specific cells without removing members, you need to apply cell-level security to a cube.
Prevent Values in Cells from Being Read
The Finance cube contains, among other things, expense information. It includes Headcount, Salary, and Benefits members. ...