Populating RAC and MDAC cubes with values

RAC and MDAC cubes can be populated with permission values from a linked data table. The linked table is a single point of truth for the permission values. When a data table is linked, any permission values that you add directly to the RAC or MDAC cube are lost. This is because the cube is purged before values from the linked table are published. Data tables are linked from the DEPM_MOD_FACTTABLE table. For the simple MDAC option, data tables are linked from the DEPM_MOD_MDACTABLE table.

To populate the RAC or advanced 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.

Currently, to populate a RAC or MDAC cube with values, perform these steps:

Create a data table that fulfills the requirements described in the "Multidimensional access cube table" topic.

Insert a new record in the DEPM_MOD_FACTTABLE object definition table. You can use, for example, this script:

INSERT INTO [DEPM_MOD_FACTTABLE] ( [CubeID], [TableName], [Order]) VALUES ('DemoBA_#MDAC_Advanced',  'DemoBA_MDAC_Analysis',1)

Note: These steps are not relevant when you selected the simple MDAC option.