Processing KPIs and Scorecards

This chapter provides an overview of key performance indicator (KPI) and scorecard processing and discusses how to run KPI and scorecard processes

Understanding KPI and Scorecard Processing

This section discusses:

• Engines used.

• Delivered jobstreams.

• KPI processing.

• Scorecard processing.

After KPI and scorecard setup is complete, processing takes place through the Performance Management Warehouse. This section assumes that you are already familiar with run controls, jobstreams, and process scheduler. Review your Performance Management Warehouse and PeopleTools documentation if these are unfamiliar terms.

This chapter provides an overview of both the KPI and scorecard processes. KPIs must be processed prior to processing scorecards. However, be aware that if you process scorecards using the supplied jobstreams, you may not need to run the KPI Analyze jobstream independently, as it is included in one of the jobstreams for scorecard assessment.

The scorecard and KPI processes both use several different PeopleSoft Application Engine programs. This section lists the engines used and the jobstream definitions that we provide with the system. These jobstreams are used to initiate the processing from the Performance Management Warehouse.

Engines Used

PeopleSoft Enterprise Performance Management applications use engines to run each process. Engine metadata is delivered with the system; unless you’re revising the application you shouldn’t need to modify it. This metadata stores information about the various PeopleSoft Application Engine programs that are used within an engine. The following table lists the delivered engines that are used by PeopleSoft Enterprise Scorecard when processing KPIs and scorecards using the delivered jobstreams and their associated jobs.

The Merge engine is used by many applications within the PeopleSoft Enterprise Performance Management suite. It moves enriched data from temporary tables into the final permanent tables for use as input for other processes. In most jobstreams, the Merge engine is the last job. (The exception to this rule is when you use the POST job last in the jobstream.) During processing, data is copied into temporary tables. When processing is complete, the final tables are updated.

Delivered Jobstreams

Each main engine is associated with a job ID using the Job Metadata page. Jobs are associated with a jobstream using the Jobstream page. A job must be unique across all jobstreams, so if you require additional jobstreams, you first need to create new jobs to use in each jobstream. The following table lists each batch process, the delivered jobstream, and the engines and job IDs that are used in that jobstream.

Note. The jobstreams listed are those that are delivered with the system. You can opt to create your own jobstreams.

KPI Processing

The KPI Analysis jobstream (KP_ANALYZE) resolves the value of key performance indicators, evaluates the KPI dimension members against their targets, and assigns the achieved assessment. Based on the business rules that you associate with a KPI, each KPI is given an assessment, or rating, that you use to identify out of tolerance conditions or performance opportunities. KPI Analysis is a batch process that you initiate by submitting a run control request. This process comprises several PeopleSoft Application Engine programs. You specify which business unit, scenario, and fiscal year and period ranges to process.

Note. You don’t need to run the KPI Analysis jobstream by itself if the scorecard assessment process that you run includes the KPI_ANALYZ engine. However, you may want to run KPI Analysis independently when initially establishing your KPIs to verify that they are set up correctly.

The KPI Analysis jobstream consists of these general steps (this is a simplified description of what actually occurs):

1. The system retrieves the KPI data elements that are used from the Performance Management Warehouse tables.

2. The system retrieves the appropriate data, using the SQL built by the data element definitions and related calculation definitions.

3. The system calculates the KPIs.

   • For calculated KPIs, the engine uses the SQL that is generated from the assigned calculation ID to process and calculate the data and determine the results.

   • For those KPIs that are derived from other KPIs (defined by the KPI Type field on the KPI Definition page), the values for the source KPIs are determined first; then the derived KPIs are assigned those values. Source KPIs are not assessed in the current run; they must be previously assessed for use with derived KPIs.

   • Manual KPIs are not calculated.

     You must enter their values prior to running KPI analyze or scorecard assessment.

   • For KPIs that have a dimension tree defined (hierarchical KPIs), the system calculates the values for each node.

4. The system determines assessment results for each KPI dimension member.

   • The system retrieves and calculates the target value for each KPI dimension member.

   • Each KPI dimension member is evaluated against its target, or the default target table, and given the appropriate assessment ID based on the target rules.

5. If any composite KPIs are defined, then the system calculates and assesses the composite KPIs.

6. The system determines and processes any actions that are required (sends emails or populates worklists) as a result of the assessment.

7. KPI information is published (if the option is selected on the KPI Options page).

8. When the process is complete, the information is merged from temporary tables to these permanent fact tables: KP_KPI_CALC_F00, KP_KPI_ASMT_F00, KP_DATAVALS_F00, and KP_TRGTVALS_F00.

The system uses the following tables during KPI analysis processing:

Note. This does not include the supporting Performance Management Warehouse tables that the system accesses: the scenario tables, the calendar tables, the metadata tables (record, tablemap, datamap, constraint, engine metadata, job metadata, jobstream metadata), record suite tables, process tables, and so on.

Scorecard Processing

The delivered jobstreams for processing scorecards are Scorecard Assessment (BC_ANALYZE), Scorecard-Only Assessment (BC_ASSESS), and Apply Manual Assessment (BC_OVRASMT). The Scorecard Assessment jobstream determines scores for the components of your scorecard. You must run this prior to viewing a scorecard. When viewing scorecards, you can override the assessments if you have the appropriate security. The Apply Manual Assessment jobstream updates the scorecard by applying the manually entered assessments and reevaluating the scores for each component.

Scorecard Assessment

During scorecard assessment processing, these steps occur:

1. The system calculates and assesses KPIs.

   (This depends on which scorecard assessment jobstream you run. Of the jobstreams that we provide, BC_ANALYZE does this step because it includes the KPI_ANALYZ engine; BC_ASSESS does not.)

2. The system generates scorecards for each user and role user that is specified on the distribution list

3. The system scores each strategy component, based on the assessment method that is defined on the Component Definition page.

4. The system merges the information from temporary tables to these permanent fact tables: BC_ASSESS_F00 and BC_PRSPCTV_F00.

The following diagram provides an overview of process flow for scorecard assessments:

Process flow for scorecard assessment

These tables are used during processing:

This lists only those tables that are used by scorecard assessment. The tables that are affected by KPI Assessment are listed in the KPI processing section.

Note. This list does not include the supporting Performance Management Warehouse tables that the system accesses: the scenario tables, the calendar tables, the metadata tables (record, tablemap, datamap, constraint, engine metadata, job metadata, jobstream metadata), record suite tables, process tables, and so on.

Manual Assessments

If you enter manual assessments when viewing a scorecard, run the Apply Manual Assessments jobstream (BC_OVRASMT) to apply those assessments and update your strategy component scores.

During manual assessment processing, these steps occur:

1. The system updates the KPI assessment using the manual assessment values.

2. The system reevaluates the strategy components.

3. The system merges the information from temporary tables to these permanent fact tables: BC_ASSESS_F00, KP_KPI_OVRD_F00, KP_KPI_ASMT_F00, and BC_PRSPCTV_F00.

The following tables are used during processing:

Note. This list does not include the supporting Performance Management Warehouse tables that the system accesses: the scenario tables, the calendar tables, the metadata tables (record, tablemap, datamap, constraint, engine metadata, job metadata, jobstream metadata), record suite tables, process tables, and so on.

See Also

KPI Processing

Assessment Methods

Running KPI and Scorecard Processes

This section discusses how to run the delivered KPI and scorecard jobstreams.

Pages Used to Run the Delivered KPI and Scorecard Processes

Running KPI and Scorecard Jobstreams

Access the Run Jobstream page or Run Multiple Jobstream page, depending on your requirements.

Complete the run parameter fields:

Warning! Do not select the As Of Dated Jobstreamcheck box. This is not supported for Scorecard applications. If you select this option, your results will be incorrect.