Only data in XML system event format can be imported for data analysis.
Existing meta data in the XML import file is ignored.
Each system event represents the data of one table row.
Example: System events
<event>
<attribute type="VBTYP">M</attribute>
<attribute type="POSNR">000010</attribute>
<attribute type="VBELN">0090018105</attribute>
</event>
<event>
<attribute type="VBTYP">C</attribute>
<attribute type="POSNR">000010</attribute>
<attribute type="VBELN">0090018147</attribute>
</event>
The attribute type corresponds to the column name.
In the example, columns named VBTYP, POSNR, and VBELN are created. The two events result in the following data series which will be imported in the analysis server.
VBRK-VBTYP |
POSNR |
VBELN |
M |
000010 |
0090018105 |
C |
000010 |
0090018147 |
If a value is missing or an attribute contains an empty string, the analysis server uses a default value instead. The default value can be changed for text dimensions. Measures and time dimensions have the default value Not maintained.
<event>
<attribute type="VBTYP">M</attribute>
<attribute type="POSNR">000010</attribute>
</event>
<event>
<attribute type="VBTYP">C</attribute>
<attribute type="POSNR"></attribute>
<attribute type="VBELN">0090018147</attribute>
</event>
VBTYP |
POSNR |
VBELN |
M |
000010 |
<DEFAULT_VALUE> |
C |
<DEFAULT_VALUE> |
0090018147 |
If an attribute is used multiple times, one of the values is randomly selected for import.
<event>
<attribute type="VBTYP">M</attribute>
<attribute type="POSNR">000010</attribute>
<attribute type="VBELN">0090018105</attribute>
<attribute type="VBELN">0090018106</attribute>
<attribute type="VBELN">0090018107</attribute>
</event>
<event>
<attribute type="VBTYP">C</attribute>
<attribute type="POSNR">000010</attribute>
<attribute type="POSNR">000020</attribute>
<attribute type="POSNR">000030</attribute>
<attribute type="VBELN">0090018147</attribute>
</event>
VBTYP |
POSNR |
VBELN |
M |
000010 |
0090018105 |
C |
000030 |
0090018147 |
During import, the analysis realm configuration is used for identifying the columns. Only attributes whose type is the same as a column name are imported. If an event does not contain any attribute types or contains attribute types not listed in the table configuration an empty table row is imported. Text dimensions receive a definable default value, and measures and time dimensions receive the value Not maintained.
After the import, the following values are output on the console:
XML system event files can be imported in ZIP format, as well. If the ZIP file contains only one XML file, the file is imported by default. If the ZIP files contains multiple files the column names are identified only once during the import of the first XML file. Therefore, all XML files in a ZIP file should contain the same columns.
The XML files are processed according to their order in the ZIP file.