Data import into process instance-independent data series adds new data rows and overwrites changed existing data rows.
If the data import is repeated, existing data rows are overwritten with changed, updated values of process instance-independent measures and referenced dimensions of the data series, and new data rows are added to the relevant data series. The PPM system recognizes existing data rows through a data series' key dimension values.
Key dimensions are determined by the iskeydimension="TRUE" attribute of the refdim element in the definition of the data series. For further information, please refer to the document PPM Customizing.
Example
The following data row has already been imported into an existing data series:
D_COUNTRY* |
D_PLANT* |
D_DEPARTMENT* |
D_RECORDED BY |
SALES |
COSTS |
Germany |
Hamburg |
42 |
Smith |
400000 |
|
Referenced dimensions marked with * are the key dimensions of the data series. Therefore, the value combination Germany; Hamburg; 42 is the identifier of the displayed data row. The two process instance-independent measures SALES and COSTS are configured for the data series.
If data import is repeated, for example, with the values Germany; Hamburg; 42; Huber;;280000, the PPM system recognizes that the data row already exists and overwrites the value of the dimension D_RECORDED BY (Schmidt) with the changed value (Huber) and adds a value for the process instance-independent measure COSTS.
D_COUNTRY* |
D_PLANT* |
D_DEPARTMENT* |
D_RECORDED BY |
SALES |
COSTS |
Germany |
Hamburg |
42 |
Huber |
400000 |
280000 |
The value of the process instance-independent measure SALES remains unchanged and is retained because no new value was imported during the repeat data import.