While adding a level at the end is straight forward, by simply adding it at the end, editing one in the middle needs a few more steps.

Levels are organized by their distance to the "ALL" level, the highest one being level 1. Suppose you have 2 two level hierarchies and want to add one in the middle.

Follow these steps:

  • In the config UI, find "Projects", "Dimensions", and the second level.  Edit the distance to root of this level, and change it to 3.
  • Now change the Excel file and include your level in the middle, and update the former 2nd level to have the distance 3. (e.g. change 2ndlevel=DIM[Dimension,Level,2] to 2ndlevel=DIM[Dimension,Level,3])
  • Upload the new Excel file. No error should occur.