Data reimport

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.