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 |
The value of the KPI |
Mandatory |
| DESC |
The 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} |
The reference date to use for the KPI value computation. The expected format is he one defined in the spagobi.xmlconfiguration file in the tag DATE-FORMAT-SERVER |
| P{ParKpiResource} |
The 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.
