Actual to Non-Target Value Comparison in the Scorecard Tab

Use

The Scorecard tab shows actual and target details for KPIs. If your model contains a Type dimension that includes dimension members such as Forecast or Benchmark, you can incorporate the Type dimension into the Scorecard tab and use that Type dimension member as an alternative to Target for the KPI. This feature allows users to be able to compare actual to forecast or actual to benchmark as well as actual to target.

Prerequisites

Only the _TAR measures should be dimensioned by the Type dimension in the model.

Features

If you implement the Type dimension, the application is changed in the following ways:

• A KPI's score and status, which by default represents the deviation between actual and target, now represents the deviation between actual and the selected Type dimension member.

• Users can click Dimension Filters in the Scorecard tab and select which member of the Type dimension they want to review in the Scorecard tab.

• All instances of Target are replaced by the currently selected Type dimension member. The system recalculates the score based on the current selection and updates the status indicators to reflect the current selection.

For example, if you are viewing the Scorecard tab and you filter on Forecast for the Type dimension, the Target, Previous Target, and Target % Change columns are replaced with Forecast, Previous Forecast, and Forecast % Change.

Activities

To incorporate a Type dimension in the Scorecard tab, from the Use Measure Type Dimension dropdown list, select the Type dimension that exists in the model.