Open in ClaudeOpen in ChatGPT
← Back to Part 1: Create a Project

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.

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

Watch the video guide

In this tutorial, you will use:

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

The Location dimension uses a hierarchy:

  • Region
  • Country

Data cube showing the Region and Product dimensions with sample aggregated values by year

Steps

  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.
  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

Result

  • Created the Product dimension
  • Created the Location dimension with a Region > Country hierarchy
  • Added the level values needed for the tutorial data
Was this page helpful?