For importing in CSV format, the following special features apply:
Example (with row numbers)
1 PIKICUBE_COSTS
2 OVERHEAD_COSTS(.,);OVERHEAD_COSTSNUM;TIME(MM.yyyy);
PROCESSTYPE;PROCESSTYPE
3 1.000,00 EUR;100;05.2000;Order processing;
Car industry
4 1.020,00 EUR;;06.2000;Order processing;
Car industry
...
Explanation
Each row represents a data series data row to be imported. The individual values are separated by the specified separator.
For the import values of the process instance-independent measure OVERHEAD_COSTS, a relevance value (OVERHEAD_COSTSNUM) of 100 (1,000.00 EUR;100) is specified in the first data row (row 3), the second data row (row 4) has no relevance value (1,020.00 EUR;;). In this case, the relevance value is automatically set to 1.
The values for two-level dimensions (in the example: PROCESSTYPE) are imported using two separate, successive columns with the same name. The first column contains the rough value, the second the detailed value.
The optional format MM.yyyy for the referenced dimension Time consists of an integer month number followed by a four-digit year number. The individual field values are separated by a full stop (see Data formats).