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


FAQs

Frequently asked questions can be found here

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.