Key Performance Indicators

If you use Vision Analysis Cubes, you can create key performance indicators (KPIs) to add to Vision custom reports. KPIs measure how well your company is meeting its business goals. You define performance goals (targets) that are specific and measurable. Then you see how well you are meeting these goals as you track variances from your goals over time.

KPIs are available for the Project data cube only.

Some KPI examples are:

KPI Groups

After you create KPIs and update the data cubes with the KPIs, the KPIs display in a KPI group that displays after the measures groups in the Excel PivotTable Field List, with the following graphic:

Within the KPIs group, you see the specific KPIs. When you click the plus sign for a specific KPI, a Value, Goal, Status, and Trend check box display for each KPI.

Important Information

  • Only one KPI can be added to a report; multiple KPIs on a single report are not supported.
  • You cannot create nested KPIs.
  • The following are four combinations of KPI measure types and status methods that you can use together when you create a KPI:
Measure Type and Status Method Combination Measure Type Status Method
1 Numeric/Amount

Percent of Goal

2

Numeric/Amount

Amount-Based

3 Multiplier or Percent

Percent of Goal

4 Multiplier or Percent

Amount-Based

  • Goals can be set against user-defined field measures, but these types of measures cannot be combined with Fiscal Period or Transaction Date dimensions. You cannot create specific (override) goals for user-defined measures.