Using MDAC cubes

You use MDAC cubes to lock areas of data cubes on cell level. These cells cannot be read or changed by role-users. You may create an MDAC scenario for each data area you lock.

The MDAC cube must contain the same dimensions as the data cube except the Group dimension. The Group dimension will automatically be assigned and assigns the locked areas to the roles.

To create an MDAC cube and an MDAC scenario:

  1. Create a cube and assign the dimensions to it.
  2. Open the Properties of the cube and select Cell Lock as the cube type. On the Cube-to-Cube Relations tab, you see the list of cubes that can be assigned to the MDAC cube. If you clear the check box Show only MDAC cubes that can be related to this cube, all cubes are displayed.
    Note: If the cube is first displayed when the check box is cleared, you must check the dimension structure.
  3. Select the check box of the cubes that can be assigned to the MDAC cube in the ID column. Click OK to close the dialog.
  4. Right-click the MDAC cube and select Add MDAC Scenario.
  5. In the Create Scenario dialog, specify a name and a description. If you clear the check box Do not create scenario with the database, the scenario is inactive and the cell areas will not be locked. Click OK. The scenario is displayed underneath the MDAC cube in the tree.
  6. To lock an area, click the scenario and select a subset.
  7. For each dimension, select one subset. If required, click the button New Subset to create a subset and select it.