How-to Updated May 13, 2026

Part 2: Set Up Dimensions

In this part, you create the dimensions, levels and level values.

Dimensions in Valsight structure data into cluster such as product, region, or time, so values can be organized, aggregated, and analyzed across different views.

image-20260415-194500.png

For detailed reference on any of the concepts here, see Dimensions.

In this tutorial, you will use:

  • Time: predefined by Valsight
  • Product: Premium, Standard
  • Location: France, Germany, USA, Canada, grouped into regions: Europe, Americas

The Location dimension uses a hierarchy:

  • Region
  • Country

Screenshot 2026-04-14 155733-20260414-135733.png


Watch the video guide

Step 1: Create the Product dimension

  1. Open the Dimension Manager from the left menu bar.
  2. Click Add to create a new dimension.
  3. Enter the dimension details:
FieldValueNotes
Dimension nameProductThe name can be chosen freely.
Level nameProductThis must match the column name in the Excel file exactly, case-sensitive.
  • Click Confirm to create the dimension.

  • Add the level values:

    • Premium
    • Standard

Tip: Level values can also be added later during data upload if they are missing.

Step 2: Create the Location dimension

  1. In the Dimension Manager, click Add.
  2. Enter the dimension details:
FieldValueNotes
Dimension nameLocation
Level nameRegionStart with the highest level.
Level nameCountryHit Shift + Enter to add another level.
  1. Click Confirm.
  2. Add the level values.
RegionCountry
EuropeFrance
EuropeGermany
AmericaUSA
AmericaCanada

What you have done

  • Created the Product dimension
  • Created the Location dimension with a Region > Country hierarchy
  • Added the level values needed for the tutorial data

Next step

Continue to Part 3: Upload and Validate Data.

Was this page helpful?