Multidimensional Data Upload (2D/3D/4D Tables)

Create a 2D/3D Data Table

If your source systems present data in some sort of formatted table rather than a structured "database like" table you can use the 2D and 3D upload functionality.

The identifier in Cell A1 has to contain the following information:

3D / LevelName1 / LevelName2 / LevelName3 / MeasureName

Fragment

Explanation

3D The identifier tells Valsight that this table should be considered a 3D table
LevelName1 The Name of the level that the data in column A belongs to. Should match a level name exactly.
LevelName2 The Name of the level that the data in column B belongs to. Should match a level name exactly.
LevelName3 The Name of the level that the data in Row 1, starting at Cell B1 (2D) or C1 (3D) belongs to. Should match a level name exactly.
MeasureName The data will be available as this column in the resulting Valsight Table.

You can also use the =DIM[Dim,Level,#] identifier for each level name to create a dimension "on the fly". However, for best results and a structured approach, you should rather have these information in separate dimension tables.

Download an example 2D / 3D / 4D upload sheet at Example Excel Sheets.

To illustrate the way a 3D upload works: the following two tables are equivalent:

3D / ExampleProduct / ExampleChannel / Year / Volume

ExampleChannel

2018

2019

Product A Online 10 40
Product B Offline 20 30

Equivalent regular upload table:

Year

ExampleProduct

ExampleChannel

Volume

2018 Product A Online 10
2018 Product B Offline 20
2019 Product A Online 40
2019 Product B Offline 30

Was this helpful?

Yes | Somewhat | No