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
• Actions for each measure:
  • Verify — starts the measure verification process
  • View lineage — shows dependencies for the measure
  • Edit — opens the measure editing dialog
  • Remove — removes the measure from the fact table (but not from the RMD)

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

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
  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.

Measure verification

The "Verify" action allows you to perform a two-step verification of any measure from the list. This helps ensure the correctness of the formula and obtain real data from connected databases.

The verification process consists of 2 steps:

Step 1: SQL script generation

The system automatically creates an SQL SELECT query based on the measure's formula from the RMD.

What happens at this step:

• SQL code is generated from the formula according to the translation rules defined in the formula language description
• Code is generated for the DBMS selected in the settings of the connection used for the fact table
• The created SQL code is displayed in a readable format (with proper indentation and line breaks, similar to SQL formatters)
• Available options:
  • Copy SQL code to clipboard
  • Export SQL code to a text file

Step 2: SQL script execution

The system provides the ability to execute the generated SQL SELECT query on connected databases.

What you can do at this step:

• View script execution results
• Depending on the formula, the result can be:
  • A single aggregated value (e.g., sum, average)
  • A column with individual results for different data records
• For non-aggregated calculations with multiple results, the system shows a table containing:
  • A column with calculation results
  • Columns with values for fields used in the script
• Export execution results in CSV format

Error handling

If the system cannot generate or execute an SQL script for a measure, a notification appears explaining:

• What went wrong (e.g., syntax error in the formula, missing database connection, non-existent field)
• How to fix the problem (if possible)

Viewing measure lineage

The View Lineage action allows you to visually trace the entire calculation chain for any measure.

What the lineage diagram shows:

1. Dependency hierarchy: The measure is displayed at the top level. Below — all elements used in its formula. If these elements are themselves measures, their dependencies are displayed, drilling down to base elements
2. Base layer: At the bottom, the final facts and dimensions are displayed, along with database tables and fields to which they are linked
3. Complete picture: The diagram combines information from the fact table's "Configuration" section — both logical relationships and physical database connections

Capabilities in lineage view mode:

• Navigation: Zooming and panning across the diagram
• View properties: Click any element (measure, fact, dimension) to see its details from the RMD
• Quick editing:
  • You can edit the measure itself by opening its dialog from here
  • You can change database connections for facts and dimensions as in the fact table configuration
• Auto-update: After saving any changes made here, the lineage diagram automatically updates