Skip to main content

Dimensions

Dimensions are used to organize descriptive data such as categories, products, regions, etc. They serve as building blocks for models and planning layouts.

Dimension Table​

From the dimension table page, you can:

  • Create, update, delete, or clone dimensions
  • Preview table data
  • Run imports
  • Export dimension data to CSV

Dimension Details​

1. Basic Info​

  • Schema Name
  • Table Name
  • Description

2. Attributes (Columns)​

Each dimension contains a list of attributes:

  • Name
  • Data Type: string, number, decimal, boolean, date, reference (foreign key)
  • Description
  • Business Key (checkbox): Identifies unique records in the table

🔒 Once a dimension is used in a planning process, attributes become locked for editing.

3. Imports​

Define how dimension data is populated:

  • From CSV – Upload and map fields manually
  • From Database – Use a saved connection and a query

4. Table Data​

The dimension also includes a data table where you can:

  • Create, update, or delete rows
  • Truncate the entire table (delete all rows)