The format of the XML file is specified by the following DTD:
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).