Skip to main content

Models

Models represent fact tables that store measurable data (e.g., sales, budgets) and foreign keys linking to dimensions.

Model Table​

From the models overview page, you can:

  • Create, update, delete, or clone models

Model Details​

1. Basic Info​

  • Schema Name
  • Table Name
  • Description

2. Measures​

Measures are the main numerical fields in your model:

  • Name
  • Data Type: string, number, decimal, boolean, date, reference
  • Description
  • Read-Only (checkbox): Only updated via import processes

3. Dimensions​

Models link to dimensions via foreign keys. You can add dimensions by dragging them from the list of available dimensions to the used list.

This defines the structure of your fact table and enables filtering and grouping in planning processes.