XML format

The format of the XML file is specified by the following DTD:

s_ppm_tr_xml_dtd_dimdata

Warning

The name of the data columns for the key and description of a dimension level must start with the prefix LEVEL and end with the suffix ID (key) or DESC (description). Additionally, please use consecutive numbers starting with 1 to specify the level. Otherwise, the import will be canceled and an error message is displayed.

The following table illustrates the assignment of data columns to the dimension values (<n> represents the consecutive numbering of the level):

dimdata configuration

Dimension configuration

Example

LEVEL<n>_ID

ID of the n-th dimension level

LEVEL5_ID

LEVEL<n>_DESC

Description of the n-th dimension level

LEVEL5_DESC

Example

For the two-level dimension Sold-to party (PRINCIPAL), three values are imported:

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

<!DOCTYPE dimdata SYSTEM "dimdata.dtd">

<dimdata>

<dim name="PRINCIPAL">

<datacols>

<datacol name="LEVEL1_ID"/>

<datacol name="LEVEL1_DESC"/>

<datacol name="LEVEL2_ID"/>

<datacol name="LEVEL2_DESC"/>

</datacols>

<datarow>

<value>DE</value>

<value>Germany</value>

<value>0000000003</value>

<value>Becker</value>

</datarow>

<datarow>

<value>FR</value>

<value>France</value>

<value>0000000092</value>

<value>Leclerc</value>

</datarow>

<datarow>

<value>EN</value>

<value>United Kingdom</value>

<value>0000000027</value>

<value>Crichton</value>

</datarow>

</dim>

</dimdata>

Warning

When importing values for multi-level text dimensions, you always need to indicate the key of the first dimension level (LEVEL1_ID).