Measure modification and redeployment
- Last UpdatedAug 23, 2024
- 2 minute read
You can redeploy a measure, whose calculations have been modified or the configurations are altered but not necessarily repopulated. The following table specifies the rule which follows Measure redeployment:
|
Modification |
Measure Table and Data Deleted |
Action Taken |
Notes |
|---|---|---|---|
|
Measure Calculation Added |
No |
A new column is added to the measure table corresponding to a new calculation. |
For one or more added calculations |
|
Measure calculation deleted |
No |
The column corresponding to the deleted calculation is removed from the measure table |
For one or more deleted calculations; deletion of the measure table column does not release the physical data and requires rebuilding the table's clustered index |
|
Measure calculation modified but the data type remains unchanged* *Will affect expressions based on this calculation |
No |
None |
For one or more modified calculations |
|
Measure calculation modified to use a different data type |
No |
The column is dropped and recreated based on the new configuration. All existing data for this calculation is lost and backfilled with Nulls. |
Only one calculation data type change is required to trigger the action |
|
Calculation Type is changed (for example, from Aggregate to Expression) |
No |
The column is dropped and recreated based on the new configuration. All existing data for this calculation is lost and backfilled with Nulls. |
Only one calculation data type change is required to trigger the action |
|
Measure calculation is renamed |
No |
The renamed calculation will appear to be a new calculation and will be treated as such. The formerly named calculation will appear to have been deleted and will be treated as such. |
For one or more renamed calculations |
|
Renaming the measure |
No |
There will be no data loss, but the measure table is dropped and repopulated. |
Data loss could occur if the source data is not available anymore. |
|
Measure data collection start date modified to a later date (moved up) |
Yes |
The measure table is dropped and recreated based on the new configuration. All data is lost, and backfilling will be required. |
|
|
Measure data collection start date modified to an earlier date (backfill) |
Yes |
The measure table is dropped and recreated based on the new configuration. All data is lost, and backfilling will be required. |