Update measure target status

The Update Measure Target Status utility automatically updates MeetsTarget column entries for all measure data, based on the MeetsTargetDirection values set for each measure.

When you update measure data in the Web Client, the measure target status is automatically updated as well. However, if you manually update measure data directly in a hierarchy data table—for example, the PerspectiveMeasureData table—you would also need to manually update the MeetsTarget column in that table for the updated data.

NOTE: Updating measures manually in the data tables is not the recommended best practice, but in some cases may be unavoidable.

Run the Update Measure Target Status utility Instead of updating target status manually. You can even use the Axiom Scheduler (job: UpdateMeasureTarget-SQL) to automatically run this utility at set times, to ensure the measure data tables stay accurate. This is particularly useful if your organization has a number of people manually updating measure data in the Desktop Client.

NOTE: This utility should not be needed when you update measure data in the Web Client’s Measure Update Form, or when Initiative owners update measure data in Initiative plan files.

The utility compares the current measure data to the set measure target and determines if the measure data meets the target. If it meets the target or surpasses it in a favorable direction, the utility enters “TRUE” into the MeetsTarget column for that measure data. If the measure data does not meet the target, the utility enters “False” into the MeetsTarget column.

In the following example, the data in the Value column matches the data in the Target column. This means that the MeetsTarget column should be “TRUE” for the measure, but the entry is “FALSE.” Running the utility will change this to “TRUE.”

PerspectiveMeasureData table showing incorrect entry (FALSE) in the MeetsTarget column for the example measurement.

When to run the utility:

  • When anyone updates measure data directly in a hierarchy measure data table
  • After running the Create Measure Data utility

To update measure target status:

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