Manage Dimensions

In the Manage Dimensions menu you'll see all the dimensions, that you have administration right to modify.

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

Dimension hierarchy

Dimension Values have a hierarchy. Child values of a parent Dimension Value are in rows below it and in columns beyond its column. So Dimension Values subs are all the DimensionValues below it until the next Dimension Value in the same Column level.

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 uses changed dimension. Field names has to be changed separately in each table.

Removing the Dimension

By clicking the delete button () the Dimension will be removed from database and an undo button will replace the edit and delete buttons. If you wish to undo the delete, you can click the undo button (), but you have to do it before you leave the Dimension taskpane-page or change the active sheet.

New Dimension

By clicking the button New Dimension -button at the bottom of the Dimension list, a new Dimension row will appear at the end of the list with a editable field for the Dimension Name. After you have given the name to the Dimension and clicked the () -button, a new sheet with the empty dimension table will be opened.

Generate Dimension

You can also generate a new dimension form a existing table or an range containing Dimension Values. Select a any cell or cells on the table or the whole range and click the Generate Dimension -button at the bottom of the Dimension list. A new Dimension row will appear at the end of the list with a editable field for the Dimension Name. Default for the dimension name is the name of first column in the table or the text in the upper-left corner of the selected range. Dimension Values will be retrieved form leftmost columns in each row. You have to save the Dimension and the Dimension Values using the Save button at the Repexel menu.