Cortex | Administration | Dimensions

Manage dimensions (Administration)

Only users who are set up as administrators in Cortex have access to this feature.


A rate table is based on one or two factors called dimensions. The dimensions drive the selection of rates from the rate table. Dimensions are project attributes, such as project complexity, location, or distance to site, that impact a rate.

How do I?

Open the Administration module

Click and select Administration from the menu. The Administration module opens in a new browser tab.

View the dimensions list

In the Administration module, click Factors > Dimensions in the options list.

Add dimensions

  1. In the Administration module, click Factors > Dimensions in the options list to show the dimensions list.
  2. Click Add.
  3. In the Dimension name box, enter a name for the dimension. The dimension can have the same name as the reference field, if you like.
  4. From the Reference field list, select the project field to associate with this dimension.
  5. If you selected a list field for the reference field, the List value section displays the list values for the field.

You can manage the list values for a reference field here, when adding or editing a dimension, or in Fields > Project fields > Fields.

Add list values one at a time

    1. Click Add above the List value section.
    2. In the Add List Item window, enter the value name and click Save.
    3. Repeat this process to add additional list values.

Add list values en masse

Important. This procedure replaces all the existing list values for the field.

    1. Click Export above the List value grid to download an Excel list values workbook.
    2. Enter the list values in the Excel workbook.
    3. Save the Excel workbook.
    4. Click Import above the List value grid and select the Excel workbook to populate the List values box.

Edit list values

    1. Select the value you want to edit and click Edit above the List value section.
    2. Change the list value and click Save.

Delete list values

Select the value you want to delete and click Delete above the List value section.

For range-type reference fields, the Range values grid displays so you can set up ranges for the Reference field.

Add range values

    1. Click Add.
    2. In the New range value window, enter the following:
      • In the Value box, enter a name for the range. For example, Small.
      • In the Start box, enter the start value for the range. For example, 100000.
      • In the End box, enter the end value for the range. For example, 250000.
      • Click Save.
    3. Repeat steps 1 and 2 to add more range values.
    4. When you finish adding range values, use drag and drop to arrange the values in the desired order.

To add range values en masse

Important. This procedure replaces all the existing range values for the field.

    1. Click Export above the Range values grid to download an Excel range values workbook.
    2. Enter the range values in the Excel workbook.
    3. Save the Excel workbook.
    4. Click Import above the Range values grid and select the Excel workbook to populate the Range values box.

Edit range values

    1. In the Range values grid, select the range value you want to edit and click Edit.
    2. Edit the values for the range as needed.
    3. Click Save to save your changes.

Delete range values

    1. In the Range values grid, select the range you want to delete.
    2. Click Delete.
  1. To save the dimension and remain on the dimension page, click Save.

To save the dimension and return to the dimensions list, click Save and close.

The new dimension appears in the dimensions list (Factors > Dimensions).

Edit dimensions

  1. In the Administration module, click Factors > Dimensions
  2. Double-click the dimension you want to edit, or select it and click Edit.
  3. Change the name, list values, or range values for the dimension, as needed.
  4. When you finish, click Save.

If you get an error message...

Cortex displays an error message when you try to edit a dimension that’s been saved on one or more portfolios, saved searches, or budgets as a factor target because it will impact the saved factor targets. You need to remove it as a target or delete the affected records before you can edit the dimension.

For details about the affected records and factor targets, click the Download list of impacted records link in the error message to download a report to Microsoft Excel.

Delete dimensions

  1. In the Administration module, click Factors > Dimensions in the options list to show the dimensions list.
  2. Select the dimension you want to delete and click Delete.

If you get an error message...

Cortex displays an error message when you try to delete a dimension that’s been saved on one or more portfolios, saved searches, or budgets as a factor target because it will impact the saved factor target. You need to remove it as a target or delete the affected records before you can delete the dimension.

For details about the affected records and factor targets, click the Download list of impacted records link in the error message to download a report to Microsoft Excel.

  1. When prompted, click Delete to confirm the deletion.

 

You can edit the dimensions provided with Cortex 365, but you cannot delete them or add new ones.