Basic Overview

To give a basic overview of the concept of Dimensions, it is important to understand that Dimensions are built as a multiDimensional room. Where tables of for example Excel store data on 2 or 3 axes, Dimensions in Valsight can store data on multiple axes. 

This multiple-axis system can be visualized by imagining a cube. In the graphic on the right, the table consists of three Dimensions and the fixed costs as a measure. In this cube, each Dimension represents one axis (Time, Product Group, Region). 

The ability to assemble the data in this cube provides advantages in terms of ordering data and getting detailed insights into various combinations of data.

Further information can be found under Working with Dimensions.                          

Starting Point

  • To understand the Valsight hierarchy and Dimension concept, have a look at the Time Dimension, which has several Levels: Year, Quarter, Month.

  • Each of these levels has so-called level values, for example, "2018" is a level value of the 'Year' level, which is part of the 'Time' Dimension.

  • A hierarchy thereby describes how level values of one level are aggregated into the next level, e.g. it contains the information that Jan-March 2018 belongs to Q1, which in turn belongs to 2018.

  • The same concept can be applied to individual needs. You can create for example a Product Dimension with the levels ProductFamily & Product or a hierarchy that contains a Dimension with levels as Business Unit or Segment.

VALUE CREATED:

  • The value that is created by unraveling every Dimension into a number of levels lies in the ability to get a detailed overview, and the ability to track data.

  • Data on the lowest level (e.g. month) can be tracked, and simultaneously aggregated into higher levels (e.g. years) for a broader overview.

Step-by-Step Approach to Creating a Dimension

Development of Valsight implementation starts with creating a Project. The next step is usually the creation of a Dimension.

To do so:

  1. Select the desired Project and navigate to the Dimension management icon in the ribbon.

  2. Click the create Dimension button in the Dimension overview, which is currently showing three default and not adjustable Dimensions, namely Assumptions, Sequence, and Time.

  3. Name the Dimension (e.g. Location)

  4. and one of the levels.

Do not worry about what Dimension level you enter (top, middle, or bottom one). You can add both parent or children levels afterward.

A step-by-step guide to adding new levels can be found here:

V2 - Adding a Custom Dimension

Best Practice

  • Each level of the hierarchy should be mutually exclusive and collectively exhaustive (MECE principle).

  • Every data point that is available on a level should be part of exactly one level entry, especially in summarized data - hence every physical Euro, case, plane, or car is part of one level value in one level of the hierarchy.

Example:

  • A company is operating in 15 countries which are all in different countries. Therefore, three hierarchy levels are created. The highest level is 'World'. The second level is 'Continents'. The third level is 'Countries'. 

  • In the Model, those 15 countries should be categorized according to the 'continents' level (EMEA, Americas, APAC). In this case, the best performing countries have been inserted as single-level values (FRA, DEU, USA, etc.) whereas the others have been summarized as 'Rest') within their affiliation.

  • Following the above rule, countries that do not belong to either of the three 'continent' levels, still need to be sorted into a level. They cannot be stored as extra level values in 'Continents' as this would place them on the same hierarchy level as EMEA, Americans, and APAC, so one level above the regular countries (not mutually exclusive).

  • Therefore, the level value Rest of World is created (collectively exhaustive). This level contains the value "RoW" that contains the values for the countries.

           

          

 

Most Common Problems Related to Models

1) How can I use Excel to create new Dimensions & Hierarchies?

What You Learned

  • What Dimensions are in Valsight
  • What Dimensions can be used for
  • How to create Dimensions in Valsight
  • Best practice for Dimension set-up

Contact

You may contact the Valsight Customer Support via:

+49 30 46799042

support@valsight.com

Availability: Mon-Fri *, 9 AM to 5 PM (Berlin, Germany) .

*Except Public holidays in Berlin, Germany.