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 |
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 |
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>
...