Skip to content

Fact table management

The main Fact tables screen displays a list of all tables in the current project version.

List elements

For each fact table, the following is displayed:

  • Name — a link that opens the table
  • Description
  • Owner (the user who created the table)
  • Created at
  • Actions:
    • Rename
    • Delete

Two buttons are available above the list: Add fact table, which starts the creation process, and Data model, which opens the overview of the whole project model.

Working with the list

  • Opening a fact table: Click on a table's name to open its configuration
  • Sorting: Available for the Name, Description, Owner and Created at fields, ascending and descending. By default the list is sorted by creation date, oldest first
  • Filtering and search: Available for the same fields. Name, Description and Owner are matched as a case-insensitive substring; Created at is filtered by a date range in your time zone
  • Pagination: The list is paged, 20 records per page by default
  • Renaming a fact table: Click the edit icon in the table's row to change its name or description
  • Deleting a fact table: Click the delete icon in the table's row to remove the table
  • Creating a new fact table: The Add fact table button at the top of the list initiates the creation process

Critical error indicator

Every fact table in the list is checked for critical errors and a row with a problem is marked with an indicator. An error is recorded when at least one element of the table has the status Archived in the RMD, or when duplicate element names are detected. The In progress status is not an error. A fact table with a critical error can still be opened, but verification of the affected measures is blocked.

Creating a new fact table

To create a table, specify the parameters:

Parameter Requirements
Name Required. Must be unique within the project version. Case-sensitive. 1–64 characters. Allowed: Latin and Cyrillic letters, digits, space, ., -, _. Must start with a letter or a digit.
Description Optional. Up to 255 characters.
Base DB table Optional. The connection and table used when the fact table is populated automatically.

What happens after creation:

  1. An empty fact table is created in the current project version
  2. It immediately appears in the list for all users of the project
  3. The system automatically opens it for configuration

If a base DB table was selected, the system offers to populate the fact table from the RMD before opening it. Populating is described on the Populating a fact table page.

Renaming a fact table

  • Available via the Rename action in the list or in the Configuration section of an open table
  • Rules for the new name are identical to those for creation. Uniqueness is checked against all other fact tables of the version, so saving the current name unchanged is allowed
  • In addition to the name, you can change the fact table's description and its base DB table
  • Changes are applied instantly for all users

Deleting a fact table

  • Available via the Delete action in the list
  • Requires confirmation, as the operation is irreversible and affects related objects
  • What is deleted together with the table:
    • The table's configuration: name, description and the list of selected elements
    • All verification filters that belong to the table
    • The relationships between the table and its dimension groups
    • The mapping links of the table and the positions of its elements on the canvas
  • What is NOT deleted:
    • The measures, dimensions, facts and dimension groups themselves — they remain in the RMD
    • The database connections used by the table
    • Copies of the table in other project versions
    • Data marts that used the table. They are kept and marked invalid, and the links between those data marts and the measures, facts and dimensions that were in the deleted table are preserved
  • The deletion is recorded in the audit log, and all users of the project are notified
  • If a table is deleted while you are viewing it, the system will redirect you to the fact tables list with a corresponding notification

Access rights

  • The list of fact tables is visible to all users of the project
  • Creating, renaming and deleting fact tables is available to the Super administrator, Administrator and Developer roles; the Analyst and Viewer roles can only view fact tables
  • All management operations additionally require a valid license