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