Delete orphaned measure data

The Delete Orphan Measure Data utility removes orphaned data records that result from changes to the hierarchy measure tables. Axiom Strategy Management administrators can use this utility to clean up unused data and ensure that deleted measure targets do not appear in reports.

When a hierarchy measure is first set up, the system creates individual rows in the respective <hierarchy>MeasureData table for each time period (frequency: month, quarter, half-year, or year) in the measure’s active period. This active period includes future dates with set targets. If that time period is shortened, the record would have a set target for those future periods but no Actuals, which could result in reporting errors.

When to run the utility:

• Ad-hoc – After a hierarchy measure (Perspective, Objective, Initiative) has had its active period shortened from the original. For example, if your organization was tracking patient falls through the end of 2020 but now wants to change the end date to December 31, 2019.
• Scheduled – Can be set up as a Scheduler job to run at set times to ensure removal of orphaned Initiative measure data.

To remove orphaned measure data:

1. In the Navigation panel, click Admin > Maintenance.
2. In the Maintenance page, click the Data Utilities tab.
3. Click the Delete Orphan Measure Data button.