Skip to content

Fact table configuration

The Configuration section opens by default when you open a fact table. Here you build its logical structure by selecting elements from the RMD.

Selecting elements from the RMD

The selection panel contains all measures, dimensions, and dimension groups from the RMD of the current project version.

  • Facts and dimensions not in a group are added directly to the central fact table
  • Measures (both base and calculated) are displayed as separate elements
  • Dimension groups: You can only select an entire dimension group. It will be displayed as a separate dimension table
  • Important: The list loads when the section is opened. Changes made later in the RMD will not be reflected until you refresh the section or save the table.

Visual data model

The system automatically builds an interactive diagram based on your selection.

Model Components:

  1. Central fact table:
    • Contains selected facts and dimensions not in a group
    • Contains surrogate keys for linking to dimension tables
  2. Dimension tables:
    • Appear for each selected dimension group
    • Contain all dimensions from that group and keys for linking to the fact table
  3. Measures:
    • Each selected measure is displayed as a separate element on the diagram
    • Links are automatically established with other measures, facts, and dimensions used in this measure's formula, as defined in the RMD
    • Selecting a measure automatically adds to the model all elements it depends on
  4. Relationship lines:
    • Show one-to-many relationships between dimension tables and the fact table
    • For measures, you can show/hide dependency lines according to their calculation formulas

Interactive diagram features

  • Zooming: Increase or decrease the zoom level of the diagram
  • Moving: Drag and drop tables and groups. Relationships are redrawn automatically
  • Viewing details: Click on the information icon for any element to see all its properties from the RMD in a pop-up panel
  • Removing an element: Click the delete icon (✕) for the element that you want to remove from the model. Removing a measure does not delete its dependencies from the model.

Saving changes

  • WARNING: Changes in the Configuration section are NOT saved automatically
  • Click the "Save" button to commit all changes: both the composition of elements and their arrangement on the diagram
  • A warning will appear if you try to leave the section without saving
  • Collaborative editing: If two users are editing the same table, the last save will overwrite the previous one. The second user will receive a warning before the overwrite occurs

Updating the model when the RMD changes

The diagram in the Configuration section does not update in real time when changes are made in the RMD. You can see the current state in one of the following ways:

  • Reopen the fact table
  • Refresh the browser page
  • Switch to another section and return to "Configuration"