Skip to content

Measures in fact tables

The Measures section displays all measures (both base and calculated) associated with the current fact table — whether selected in the "Configuration" section or added through this section. This section also provides functions for creating new measures, editing existing ones, and verifying them.

Measures list

For each measure, the following information from the RMD is displayed:

  • Block
  • Name
  • Description
  • Data type
  • Restrictions
  • Formula
  • Comment

The list supports pagination, sorting and filtering by column, like the other tables in the product.

A row can also carry status indicators:

Indicator Meaning
Connection active The database connection used as the source of the measure is available
Aggregate function The formula contains an aggregate function (SUM, AVG, COUNT, MIN, MAX)
Circular dependency The formula references itself directly or through another measure
Health icon The overall health status of the measure. Hovering over it shows the health summary — see the Measure health cards page

Actions

Action Description Availability
Verify Generates the SQL query for the formula and lets you execute it Only for measures that have a formula, with an active connection and without critical errors in the elements used
View lineage Shows what the measure is calculated from Always
Edit Opens the measure editing dialog Role with edit rights and a valid license
Delete Removes the measure from the fact table (but not from the RMD) Role with edit rights

Verify is greyed out when the measure or any element of its formula has a critical error; the tooltip then reads "Invalid measures/dimensions are used to calculate this measure". Verification is described in full on the Measure verification page, and the lineage diagram on the Lineage and impact analysis page.

Adding a new measure

The "Add measure" button opens a dialog for creating a new measure. The new measure will be saved simultaneously to the current fact table and to the RMD of the current project version.

Required information

Field Requirements
Name Required. Must be unique among all existing measures and dimensions in the relevant RMD version. Requirements are the same as for the Measure name column in the RMD.
Formula Required. Entered as text in the formula editor (as in the RMD).

Optional information

  • Block
  • Description
  • Data type
  • Restrictions
  • Comment
  • A filter for the measure

Interface features

  • Optional fields are hidden by default
  • You can show/hide these fields as needed
  • Input fields correspond to the field types of the relevant columns in the RMD

Saving process

  • Changes in the dialog are NOT saved automatically
  • Click "Save" to add the measure. After saving:
    1. The measure is added to the measures table in the RMD of the current project version. If a formula was entered, its type is set to calculated
    2. The saved measure and all its dependencies (from the formula) are automatically added to the fact table configuration
    3. The measure immediately appears in the list for all users who open the "Measures" section
    4. You are returned to the "Measures" section
  • If you try to leave the dialog (e.g., by switching to another screen), a system warning will appear asking about saving
  • You can exit the dialog without saving at any time; no additional confirmation is required

Editing an existing measure

The "Edit" action opens a dialog pre-filled with the measure's current data. It functions identically to the "Add measure" dialog.

Editing rules

  • You can edit any field shown in the dialog (Name, Block, Description, etc.)
  • Requirements for each field are the same as when adding a measure
  • Fields that exist in the RMD but are not displayed in the dialog (e.g., measure type) cannot be changed here
  • If the Formula changes, the fact table configuration is automatically rebuilt to reflect the new dependencies

Saving changes

  • Click "Save" to apply changes. Before saving, a confirmation warning appears, stating that the change will affect all users and project elements using this measure
  • After saving:
    1. Changes are applied in the "Configuration" section of the fact table (links are updated if the formula changed)
    2. Corresponding fields are updated in the RMD
  • You can exit the edit dialog without saving at any time; no additional confirmation is required