PIKIDATA format

The data extracted is to be written as process instance-independent measures (PIKI) to an XML output file for the PPM import using the runpikidata.bat command line program.

The XML configuration file has the following basic structure:

...

<pikidatamapping>

<pikicube name="...">

<pikicolmapping>

<datacol name="..."/>

<keyspec key="..."/>

</pikicolmapping>

...

</pikicube>

...

</pikidatamapping>

XML element

XML attribute

Description

pikidatamapping

 

Root element of mapping definition. Contains a list of PPM measure series to be configured.

pikicube

name

Identifier of PPM measure series (corresponds to the value of the name XML attribute for the measure
series configuration in PPM)

pikicolmapping

 

Groups configuration elements for a data column

datacol

name

Name of the data column in which the PIKI values are saved (corresponds to the internal name of the PIKI in the measure configuration)

 

format
(optional)

Format string for transformation of data value

keyspec

key

Name of the key for the key-value assignment

 

desckey

Name of the key for the key-description assignment

value

 

Value of the process instance-independent measure

The file extract below shows the existing
PCA Import PPM measure series:

...

<pikicube name="PIKICUBE_TURNOVER">

<description language="de" name="PCA-Import"/>

<description language="en" name="PCA Import"/>

<pikidef name="TURNOVER" retrievertype="NUM_KEYINDICATOR"

dimreferring="LOOSE" kigroup="KI_GROUP_COST">

<description language="de" name="Umsatz">

Umsatz

</description>

<description language="en" name="Sales revenues">

Sales revenues

</description>

<datatype name="COST"/>

</pikidef>

<refdim name="VKORG"/>

<refdim name="DIVISION"/>

<refdim name="TIME" refinement="BY_MONTH"/>

</pikicube>

...

Example

The following key-value pairs are the expected result of the extraction in the XML output file in PPM system event format:

<?xml version="1.0" encoding="ISO-8859-1"?>

<!DOCTYPE eventlist SYSTEM "event.dtd">

<eventlist>

<event>

<attribute type="MARA-TURNOVER">225489 EUR</attribute>

<attribute type="MARB-VKORG_ID">1000</attribute>

<attribute type="MARB-VKORG_DESC">Germany Hamburg

</attribute>

<attribute type="DIM_ROUGH_ID">01</attribute>

<attribute type="DIM_ROUGH_DESC">Product category 01

</attribute>

<attribute type="DIM_DETAILED_ID">8112</attribute>

<attribute type="DIM_DETAILED_DESC">8112 description

</attribute>

<attribute type="CAL-TIME">January 2002</attribute>

</event>

<event>

<attribute type="MARA-TURNOVER">135699 EUR</attribute>

<attribute type="MARB-VKORG_ID">4000</attribute>

<attribute type="MARB-VKORG_DESC">Austria Vienna

</attribute>

<attribute type="DIM_ROUGH_ID">01</attribute>

<attribute type="DIM_ROUGH_DESC">Product category 01

</attribute>

<attribute type="DIM_DETAILED_ID">8112</attribute>

<attribute type="DIM_DETAILED_DESC">8112 description

</attribute>

<attribute type="CAL-TIME">January 2002</attribute>

</event>

<event>

<attribute type="MARA-TURNOVER">363521 EUR</attribute>

<attribute type="MARB-VKORG_ID">1000</attribute>

<attribute type="MARB-VKORG_DESC">Germany Hamburg

</attribute>

<attribute type="DIM_ROUGH_ID">07</attribute>

<attribute type="DIM_ROUGH_DESC">High Tech</attribute>

<attribute type="DIM_DETAILED_ID">9128</attribute>

<attribute type="DIM_DETAILED_DESC">9128 description

</attribute>

<attribute type="CAL-TIME">January 2002</attribute>

</event>

</eventlist>

The mapping file below transfers the key-value pairs into the PPM-compatible XML format for importing PIKI values:

...

<pikidatamapping>

<pikicube name="PIKICUBE_TURNOVER">

<pikicolmapping>

<datacol name="TURNOVER"/>

<keyspec key="MARA-TURNOVER"/>

</pikicolmapping>

<pikicolmapping>

<datacol name="VKORG"/>

<keyspec key="MARB-VKORG_ID"
desckey="MARB-VKORG_DESC"/>

</pikicolmapping>

<pikicolmapping>

<datacol name="DIVISION"/>

<keyspec key="DIM_ROUGH_ID"
desckey="DIM_ROUGH_DESC"/>

</pikicolmapping>

<pikicolmapping>

<datacol name="DIVISION"/>

<keyspec key="DIM_DETAILED_ID"

desckey="DIM_DETAILED_DESC"/>

</pikicolmapping>

<pikicolmapping>

<datacol name="TIME" format="MMM yyyy"/>

<keyspec key="CAL-TIME"/>

</pikicolmapping>

</pikicube>

</pikidatamapping>

Using this mapping file generates the following XML output file when you run the program:

...

<pikidata>

<pikicube name="PIKICUBE_TURNOVER">

<datacols>

<datacol name="TURNOVER"/>

<datacol name="VKORG"/>

<datacol name="DIVISION"/>

<datacol name="DIVISION"/>

<datacol name="TIME" format="MMM yyyy"/>

</datacols>

...

<datarow>

<value>225489 EUR</value>

<value>1000{Germany Hamburg}</value>

<value>01{Product category 01}</value>

<value>8112{8112 description}</value>

<value>January 2002</value>

</datarow>

<datarow>

<value>135699 EUR</value>

<value>4000{Austria Vienna}</value>

<value>01{Product category 01}</value>

<value>8112{8112 description}</value>

<value>January 2002</value>

</datarow>

<datarow>

<value>363521 EUR</value>

<value>1000{Germany Hamburg}</value>

<value>07{High Tech}</value>

<value>9128{9128 description}</value>

<value>January 2002</value>

</datarow>

...

</pikicube>

</pikidata>

...