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 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. |