Skip to content

Data mart management

The main Data marts screen displays all data marts in the current project version.

List elements

For each data mart, the following is displayed:

  • Name — data mart identifier. Used when generating the name of the data mart view in the database
  • Description — optional description
  • Owner — user who created the data mart
  • Created at — creation date and time
  • Fact tables — names of fact tables used in this data mart (clickable to open)
  • Actions:
    • Verify — check data mart configuration and preview results
    • Rename — change name and description
    • Delete — delete the data mart

Working with the List

  • Filtering and Search: Available across all displayed fields
  • Opening fact tables: Click any fact table name to open it directly from the list
  • Creating a new data mart: Use the "Add data mart" button.

Creating a new data mart

To create a data mart, specify the required parameters:

Parameter Requirements
Name Unique within the project version. Case-sensitive. 1–64 characters. Allowed: letters, digits, space, ., -, _. Cannot start with a special character.
Description Optional, up to 255 characters.

Additional configuration:

  • Data mart type: "With grouping" (aggregated) or "Without grouping" (non-aggregated) — defaults to "With grouping"
  • Merge type: "UNION" (default) or "JOIN" (only for aggregated data marts)

After creation:

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

Cloning a data mart

You can create copies of existing data marts to reuse configurations.

What is copied:

  • Links to fact tables
  • Selected dimensions (both individual and from groups)
  • Selected facts
  • Selected measures
  • Defined filters
  • Defined aggregation levels

What is NOT copied:

  • Links to created views in the database

Cloning process:

  • Available in the "Add data mart" dialog
  • Same requirements as for new data marts
  • The system automatically opens the cloned data mart after creation

Renaming a data mart

  • Available via the "Rename" action in the list or on the configuration screen of an open data mart
  • Rules for the new name are identical to those for creation
  • In addition to the name, you can change the data mart's description
  • Changes are applied instantly for all users

Deleting a data mart

  • Available via the "Delete" action
  • Requires confirmation, as the operation affects all users
  • Deletion is not possible if a view for the data mart has been created in the database. First, you must delete the created view, and only then can you delete the data mart
  • Permanently deleted:
    • Data mart configuration (name, description, selected elements)
    • Links to used fact tables
  • NOT deleted:
    • Original measures, dimensions, metrics in the RMD
    • Used fact tables
    • Copies of the data mart in other project versions