Combining Custom Views with Dimension Views

You can add custom views to a cube that already has dimension views. Use this combination when you must control access to certain information (such as salaries) based on a user's security classification, but do not need to restrict access to the remaining data.

For example, suppose you create a cube group that includes separate cubes for Central Europe, the Americas, and the Far East. For each cube, additional protection is imposed by creating custom views that group OLAP report users separately from security administrators for each region. When the cubes and the accompanying authentication sources are released to users in each region, regional security administrators can maintain security definitions for their own regions.

We do not recommend using dimension views as the basis for custom views if auto-partitioning is in place. In very large cubes with complex partitioning schemes, test your design to ensure that combination views do not increase cube creation time.

Procedure

  1. Create all the cube groups and dimension views you need for the model.
  2. Create and apply custom views to the objects in the PowerCubes list.
  3. On the Dimensions tab of the PowerCube property sheet, select the appropriate dimension views.
  4. Create and deploy your secured PowerCubes.