Defining a RAC or advanced MDAC cube in the object definition tables

Defining a RAC or advanced MDAC cube is currently not supported by the OLAP Modeling user interface. This procedure helps define RAC and advanced MDAC cubes directly in the Object Definition Tables until an appropriate function is available in OLAP Modeling.

For MDAC cubes, consider the advanced approach only if the simple MDAC option is not suitable. For more information on simple and advanced MDAC cube approaches, see "Multidimensional access cube table".

Note: Use a script or the export and import options to extend appropriate OLAP objects in the object definition tables in relational modeling.

Select Dashboards > Data Integrations > Relational Modeling.
To define the basics of the RAC or MDAC cube, use the Cube table (DEPM_MOD_CUBE) and specify this information:
ID

Specify the ID of the cube.

ModelName

Specify the name of the model.

Name

Specify the name of the cube.

CubeType

Specify 4 for a RAC cube or 2 for an MDAC cube.

DefaultPermissionValue
If different to the global default permission for the OLAP database, specify one of these values:
- 0 for the NONE permission
- 1 for the READ permission
- 2 for the WRITE permission
To define the dimensionality of the RAC or MDAC cube, use the Dimension in Cube table (DEPM_MOD_DIMENSIONINCUBE). Insert a record for each dimension. For each record, specify the cube ID, dimension ID, and the order of the dimensions in the cube.

Note: Ensure that you use only the dimensions of the cube to which to assign the RAC or MDAC cube. Do not include the Roles dimension (#_GRP_). #_GRP_ is a system dimension and is included automatically when the access cube is published.
To assign the RAC or MDAC cube to a data cube, use the Cube Assignment table (DEPM_MOD_CUBEASSIGNMENT). Specify the IDs of the data cube and access cube.

Note: CubeID and AccessCubeID are references to cubes in the DEPM_MOD_CUBE table. You cannot assign a RAC cube to another RAC cube or an MDAC cube to another MDAC cube. AccessCubeID allows only references to cubes of the RAC and MDAC types.
To populate the RAC or MDAC cube with values, use either the fact table mapping in the DEPM_MOD_FACTTABLE table or OLAP cube mappings.

Note: When you use the mapping in the DEPM_MOD_FACTTABLE table, ensure that only one table with permission values is mapped to an access cube. If multiple tables are mapped to the same access cube, only the table with the highest order value is relevant.