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
The identifier tells Valsight that this table should be considered a 3D table
The Name of the level that the data in column A belongs to. Should match a level name exactly.
The Name of the level that the data in column B belongs to. Should match a level name exactly.
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.
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
Equivalent regular upload table:
You may contact the Valsight Customer Support via:
+49 30 46799042
Availability: Mon-Fri *, 9 AM to 5 PM (Berlin, Germany) .
*Except Public holidays in Berlin, Germany.