Manage Dimension Values

When the Dimension Value sheet is open, you can see the Dimensio Value Name in the last column in the header and each Dimension Value on a separate row on the table. Columns indicate the level in the hierarchy.

By clicking play button () a new sheet will be opened with a table that contains Dimension Name and all the Dimension Values.

Renaming Dimension Value

You can rename a DimensionValue simply by replacing the name in the cell. The cell will get a comment indicated with colored edge at the topright corner of the cell. Hovering the indicator will reveal the content and the replaced value of the cell is written after Original: -keyword.

Changing the hierarchy

You can change the hierarchy by changing the structure of the Dimension table. If you are not renaming any DimensionValues then first delete the content of the cell and then give the new name. If any comments are linked to a cell that has keyword "Original" (F.ex Original: oldName), then that name will be replaced with the new name in the cell at the database.



Changing the Dimension name

Dimension Name can be changed by changing the name in the Dimension table header. Changing the name will not automatically affect the field names that are using the changed dimension. Field names has to be changed separately in each table.

Save the Changes

To save the modifications of the Dimension to the database, click the save button at the Repexel -menu. Confirmation screen will appear and the Dimension modification will be saved to the database if you confirm. You cannot undo the modifications after confirmation.