Edit a Dimension
- Last UpdatedFeb 12, 2024
- 2 minute read
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 a deployed dimension, then the state of the dimension changes to "Deployed with pending changes". After you edit 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:
|
Existing field data type |
Convertible to |
|---|---|
|
Boolean |
String |
|
Byte |
String, Int16, Int32, Int64, Decimal, Double |
|
DateTime |
String |
|
DateTime2 |
String |
|
Decimal |
String, Double |
|
Double |
String |
|
Int16 |
String, Int32, Int64, Decimal, Double |
|
Int32 |
String, Int64, Decimal, Double |
|
Int64 |
String, Decimal, Double |
|
Guid |
String |
|
String |
String |
|
Other |
N/A |
Edit a dimension
-
Open the AVEVA BI Gateway Model Builder.
-
Under the Dimensions section, click the dimension that you want to edit. The Dimension editor appears with the selected dimension details.
-
Do the required modifications.
-
Click Save.
-
If the dimension was deployed and changes were saved, it will be marked in the Explorer with a Black tag indicating that redeployment is required. This may affect the dependent measures, which will also be marked for redeployment.
Important: If you delete a dimension field, then a confirmation message appears. The system deletes the column and data of the deleted dimension field from the dimension table.