Data Discovery - Cube settings and validation

[Cloud release: 2025.07.02]
[On-prem release: 2025 October]
[On-prem build: 25.10.10001]

New features in cube creation for Data Discovery cubes provide better control, reliability, and guidance.

• If a cube reload fails, it can retain the old data to prevent disruptions.
• Users can decide whether a data source should automatically trigger a cube reload.
• There’s also an option to perform a full cube reload, including reloading all underlying data sources.
• Another improvement allows users to disable the automatic generation of measures from dimension tables.
• Additionally, warnings will now assist in the cube creation process by flagging potential issues, such as selecting multiple fact tables or creating relationships between them.

Cube settings can be accessed either from the cubes overview page, or during the creation or editing of a cube.

From the cubes overview page:

During creation or editing of a cube:

The cube settings dialog will look like this:

Use old cube data if reload failed

If a cube update fails, this setting allows the system to restore the individual cube to its last known working state.

Note: The default setting is to 'Use global setting'. The global settings are accessed from the Data Discovery main page (you must be a Data Discovery Administrator to access the global settings). Data Discovery global Settings:

Disable measure generation for dimension tables

Prevents automatic generation of measures for dimension tables during cube creation or updates. This can be useful when dimension tables are not intended to contain measurable data.

Enable cube validation

Enables additional validation checks for the cube, such as structure validation and advanced diagnostics. This helps identify potential issues and optimize cube configuration.

Show validation popups on UI

Displays validation messages as pop-up notifications in the user interface when issues are detected during cube creating or editing. This helps users quickly identify errors.

Enable many-to-many validation

Activates validation of many-to-many relationships within the cube. This helps detect and handle complex joins between tables that may affect data accuracy and performance

Note: When multiple relationships exist between tables, enabling many-to-many validation can impact server performance

More on Cube validation

If cube validation is enabled in the settings, all changes made to the cube during creation or editing are automatically validated in the background—both on the UI and on the server.

Validation also occurs whenever related components are modified, such as when data sources used by the cube are deleted or updated.

If there are existing validation messages for a cube, they can be viewed on the cube overview page. A warning icon will be displayed next to the cube name. Clicking this icon opens a dialog showing all validation messages related to that cube.

During cube creation and editing, changes are also validated in real time. The validation status is displayed next to the cube settings icon.

A checkmark indicates that no issues were found.

 A warning icon means there are validation problems.

Click the warning icon to display the list of related validation messages.

When the Show validation popups on UI setting is enabled, warning and error messages may appear as pop-up notifications during cube creation. This provides immediate feedback on issues that need to be addressed.

Examples:

Supported validation rules: