Scribd
Upload
3 views4 pages

How to Create a Data Set for KPIs

This document describes how to create a data set for a key performance indicator (KPI). A data set is used to compute a KPI's value and can include parameters like the date, resource, and custom parameters. Standard parameters include the reference date (P{ParKpiDate}) and resource name (P{ParKpiResource}). Data sets must return values for the KPI value, description, and optional end date. An example shows a query-based data set that uses custom parameters in the computation rule.

Uploaded by

chaimae
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views4 pages

How to Create a Data Set for KPIs

This document describes how to create a data set for a key performance indicator (KPI). A data set is used to compute a KPI's value and can include parameters like the date, resource, and custom parameters. Standard parameters include the reference date (P{ParKpiDate}) and resource name (P{ParKpiResource}). Data sets must return values for the KPI value, description, and optional end date. An example shows a query-based data set that uses custom parameters in the computation rule.

Uploaded by

chaimae
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Data Set Definition

Alessandro Taurelli
2011/02/11 22:14

Content - Data Set Definition

Table of Contents
How to create a Data Set .......................................................................................................................................................... 3

Page 2 - last modified by Alessandro Taurelli on 2011/02/11 22:14

Content - Data Set Definition

How to create a Data Set


Every KPI uses a Data Set to execute the computation of its value. This execution could depend on a couple of parameters
where one is based on the generic resource, that the KPI is computed on, and the other is the date on which the computation
is performed. The possible values returned by the Data Set will have to have the following aliases:
VALUE

T he value of the KPI

Mandatory

DESC

T he description of the KPI Value

Optional

END_DATE

The validity end date that override the one calculated form the periodicity of the KPI
Format: dd/MM/yyyy hh:mm:ss

Optional

Moreover, you have the possibility to insert some parameters in your Data Set. The standard parameters that you can add
are:
P{ParKpiDate}

T he reference date to use for the KPI value computation. The expected format is he one defined in the
[Link] configuration file in the tag DATE-FORMAT-SERVER

P{ParKpiResource}

T he resource name (from the SBI_RESOURCES tables) that is used for the KPI value computation.

These parameters don't need to be added in the Kpi Document. If not added they will get the default values, explained
below. If you want to add other parameters that are not the standard ones you will have to add them mandatorily in the Kpi
Document or your kpi value will not be calculated. An example of a custom parameter is in the next screenshot:
P{OtherPar}

Define the OtherPar in the Data Set Analytical Drivers as shown and use it inside the Data Set computation rule:
for the query: P{OtherPar}.

The next screenshot shows a query type Data Set.

Page 3 - last modified by Alessandro Taurelli on 2011/02/11 22:14

Content - Data Set Definition

Page 4 - last modified by Alessandro Taurelli on 2011/02/11 22:14

You might also like