Editing a Dimension

When editing a dimension, you can:

• Modify the dimension field names and mappings.

• Add or delete dimension fields.

• Modify fields data type.

• Modify the refresh rate.

• Re-configure time-slicing.

• Re-configure dimension links.

• Re-configure the filter expression.

If you edit and check in a deployed dimension, then the state of the dimension changes to "Pending Changes". After you edit and check in the dimension, the system shows a message warning about the dependent measures that can be affected by the modifications.

You can modify the dimension field data type only if the existing data type is implicitly convertible to the new data type. If the data type is not convertible, then you can delete the existing dimension field and add a new field.

The following table lists the convertible data types:

For more information about run time handling of the data store after modifying deployed dimensions, see Datastore Updates Resulting from Modifications to Deployed Dimensions.

For more information about run time handling of the on-going processes after modifying deployed dimensions, see Run time Handling of Deployed BI Gateway Objects.

To edit a dimension

1. Open the BI Gateway Model Builder.

2. Under the Dimensions section, click the dimension that you want to edit. The Dimension editor appears with the selected dimension details.

3. Do the required modifications.

4. Click Save.

5. If the dimension was deployed and changes were saved, it will be marked in the Explorer with a Black tag indicating that a (re) deployment is requirements may also have affected the dependent measures which will also be marked.

   Important: If you delete a dimension field and check in the dimension, then a confirmation message appears. After you check in the dimension, the system deletes the column and data of the deleted dimension field from the dimension table.