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.