Cube Validation

Cube validation can be applied to the measures dimension, on String Elements. This provides users performing data-entry a list of valid options derived from an existing, mapped, dimension.

Accessing Validations on Workviews

To access the Data validation menu:

1. Open a workview and ensure the target measure (or measures) are visible in the report.
2. Select a data cell associated with the target measure.
3. Click the top right menu option for data validation.

In MODLR Cubes, validation can cascade from one measure to the next allowing for contextual menus to be used for complex mapping processes.

INFO

• Although a validation must be accessed through a workview, it is saved against the Cube itself, not the workview.

Example Validations

• Simple Validation
• Formula Validation
• Cascading Validation