Managing the properties of a cube
- Select Dashboards > Data Integrations > OLAP Modeling.
- Select the model and cube.
-
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 source table with the Permission values or click Create New and a table is created by the system. After you click Create New, perform these steps:
- In the Create Multidimensional Access Control Cube dialog box, specify the name of the table and, optionally, a description.
- Click Next.
- 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.
- Click Finish.
The selected or created table is a single point of truth for permissions. Any permissions that you add directly to the MDAC cube are lost. This is because the cube is purged before values from this table are published.
The MDAC cube with the
#<CubeName>
name is created by the publishing process. Additional MDAC cubes are created with the_<n>
suffix, wheren
is a number.
- Click Save.
- Number formats
- Cache partitioning
- Cube transaction logging
- Changelog