Setting up a Domain cube in the object definition tables

When you set up a Domain cube in the object definition tables, the Perspective and Domain_System dimensions are created automatically. The Domain_System dimension is created with the implicit hierarchy that contains these numeric base elements:

  • Applicable
  • Configuration

The Domain_System dimension is treated as a system dimension.

Note: Do not use the PublishCustomCubeToOLAP function to publish Domain cubes. Domain cubes are published with the model only.
  1. Create a new record in the DEPM_MOD_CUBE table for the Domain cube and set the CubeType property to 5.
  2. Create new records for each driver dimension in the DEPM_MOD_DIMENSIONSINCUBE table.
  3. Create one or multiple domain fact tables for the Domain cube. The tables must include these columns:
    • Columns for each driver dimension.

      The driver dimension must be a record in the DEPM_MOD_DIMENSION table and referenced by the dimension name.

    • A column for the perspective of a cube.

      The perspective must be a record in the DEPM_MOD_PERSPECTIVE or DEPM_MOD_CUBE tables.

    • A column for values.

      If the perspective is applicable, the valid value is 1.

  4. To map the Domain cube with the domain fact tables, create one or multiple records in the DEPM_MOD_DOMAINTABLE table.
    If you publish from those tables, then all values are cleared in the cube and the values from the Domain table are imported.