Methods of creating multidimensional access cubes

Before assigning cell data access permissions to cubes, you must create the multidimensional access cube and appropriate roles in EPM Administration. To assign access rights to dimension elements in a database, you must have Administrator OLAP Database permission to that database.

There are different ways to create multidimensional access control cube depending on what modeling tool is being used. This table describes the tools and methods for MDAC creation:

Component Task Reference
Designer Create new MDAC cube with Cell Lock type, create MDAC cube name (preferably starting with # symbol) and add dimensions the needed to be included into MDAC cube.

Select the cube that should be secured, open properties and use the Cube-to-Cube Relations tab to assign the MDAC cube to it.

Permissions

Using MDAC cubes

ImportMaster You cannot create a MDAC cube in ImportMaster. See the ImportMaster online help.
EPM Administration Select the Enable Cube Access Control option on the Database Structure dashboard and either select an existing MDAC Cube or create a cube using the Create New Cube option. Creating a Multidimensional Access (MDAC) cube

Access control

Editing cube properties

Infor Business Vault You cannot create a MDAC cube in Infor Business Vault. See the Infor Business Vault documentation.