Managing the properties of a cube

  1. Select Dashboards > Data Integrations > OLAP Modeling.
  2. Select the model and cube.
  3. On the Properties tab, edit any of these properties:
    • Default Caption or language-specific captions. To edit language-specific captions, click the icon above the Default Caption field.
    • Default Description or language-specific descriptions. To edit language-specific descriptions, click the icon above the Default Description field.
    • Measure Dimension

      Select the measure dimension. We recommend that you select the measure dimension to benefit from the number formatting options. See "Number formats".

    • Format Dimension

      Select the format dimension.

    • Cache Partition Dimension

      Select the cache partition dimension.

    • Enable Cube Access Control. If enabled, the permissions that are defined in the Table Access Control Cube (#_TABACC) are activated.
    • Enable Transaction Log. If enabled, all changes to the cube are logged except for the cell note changes. You can use the log for recovery purposes, for example.
    • Enable Changelog. If enabled, every cell change for configured operations is logged.
      Note: You must first enable the Enable changelog option in the Database Settings dashboard.
    • Enable Multidimensional Access Control. If enabled, the permissions that are defined in the Multidimensional Access Control Cube (MDAC) are activated.

      If you enable multidimensional access control, you must select the MDAC simple or advanced option.

      If you select Simple, then, from the list, select one or multiple source tables with Permission values. The MDAC cube with the #<CubeName> name is created by the publishing process. If you selected multiple tables, additional MDAC cubes are created with the _<n> suffix, where n is a number.

      If you select Advanced, then, from the list, select one or multiple MDAC cubes.

      Instead of selecting the tables or cubes, you can click Create New and, depending on which MDAC option you selected, a table or cube is created by the system. After you click Create New, perform these steps:

      1. For the simple MDAC option, in the Create Multidimensional Access Control Cube dialog box, specify the name of the table and, optionally, a description.

        For the advanced MDAC option, in the Create Multidimensional Access Control Cube dialog box, specify the name and default caption of the cube and, optionally, a description.

        Note: The cube name must be unique within the model. The cube name and default caption must comply with character limits and restrictions. If you specify invalid information, error icons and tooltips that indicate an issue are displayed.
      2. Click Next.
      3. In the Available Dimensions section, select the required dimensions and click the arrow icon to move them to the Selected Dimensions section. To select multiple dimensions, either press SHIFT on your keyboard and then select multiple adjacent dimensions, or press CTRL and select multiple dimensions.
        Note: The list of available dimensions is limited to the dimensions of the cube for which the MDAC cube is used. Do not include the roles dimension (#__GRP__). This is a system dimension and is included automatically when the access cube is published.
      4. Click Finish.

        The table or cube is automatically added to the list of cubes.

    • Enable Relations Access Control. If enabled, you must select one or multiple RAC cubes or create a new one. To create a new RAC cube, click Create New and perform these steps:
      1. In the Create Relations Access Control Cube dialog box, specify the name and default caption of the cube and, optionally, a description.
        Note: The cube name must be unique within the model. The cube name and default caption must comply with character limits and restrictions. If you specify invalid information, error icons and tooltips that indicate an issue are displayed.
      2. Click Next.
      3. In the Available Dimensions section, select the required dimensions and click the arrow icon to move them to the Selected Dimensions section. To select multiple dimensions, either press SHIFT on your keyboard and then select multiple adjacent dimensions, or press CTRL and select multiple dimensions.
        Note: The list of available dimensions is limited to the dimensions of the cube for which the RAC cube is used.
      4. Click Finish.

        The cube is automatically added to the list of cubes.

  4. Click Save.
Related topics