Multidimensional access cube table

The DEPM_MOD_MDACTABLE table assigns a data table that is used to fill data into an MDAC of a cube that was created with the simple approach.

Simple approach

The simple approach allows you to set up a cube with predefined standards. The simple approach includes these options:

  • Pre-created data table

    When you apply the simple approach in OLAP Modeling, then a data table with all required columns is created. You can use the columns to populate a cube with values.

  • Standard names, captions, and descriptions

    The names, captions, and descriptions of a cube are pre-defined, which facilitates the cube set-up and use. Less customization is required. You cannot include the cube in the DEPM_MOD_CUBE table.

Advanced approach

You can use the advanced approach for complex scenarios. The advanced approach provides these benefits:

  • More flexibility and customization options.
  • Editable captions and descriptions of a cube.
  • Association with multiple data cubes. You can link the MDAC with multiple data cubes. This facilitates the efficient use of sharable MDAC cubes.
Note: You cannot combine the simple and advanced approaches on the same cube.

This table shows the definition of the multidimensional access cube table:

Name Definition
CubeID nvarchar(50) NOT NULL; PK
TableName nvarchar(50) NOT NULL; PK

CubeID refers to the cube that the MDAC is applied to.

MDAC name and description are controlled by the system.

The table has these references:

Source columns Target table Target columns
CubeID _cube ID
TableName _table Name