Expert Cube Development with SSAS Multidimensional Models

Data security

There are three different types of data security that we can implement: we can grant members of a role permission to access entire cubes; and we can control access to data within a cube by granting or denying access to individual cells (Cell security) or individual members on dimension hierarchies (Dimension security).

Granting Read Access to Cubes

Before a user can access any data in a cube, they need to be a member of a role that has Read permissions on that cube. A role can be granted Read permission on a cube by selecting Read on the Access drop-down box next to the cube name on the Cubes tab of the Role Editor as shown in the following screenshot:

If we have set up Writeback on our cube, we can also control whether the Role can ...