Write Mode Example

Overwrite mode

The dimension and attribute values in Planning and Consolidation are replaced/overwritten by the newly imported masterdata.

Example

Original masterdata account:

IDs	Attribute
CE0004830	A
CE0065000	B
CE0002000	C

New masterdata account:

IDs	Attribute
CE0010000	E
CE0002000	D

Final masterdata account:

IDs	Attribute
CE0010000	E
CE0002000	D

Note Note

If masterdata is occupied by transaction data or hierarchies in the application, then the masterdata is not deleted, whereas other masterdata that is not occupied by transaction data is deleted. The system returns a message in the log. The status of the Data Manager package is Failed.

End of the note.

Update mode

The masterdata in in Planning and Consolidation are overwritten by the newly imported masterdata if the values are the same; the other masterdata are retained.

Example

ID is the key.

Original masterdata account:

IDs	Attribute
CE0004830	A
CE0065000	B
CE0002000	C

New masterdata account:

IDs	Attribute
CE0010000	E
CE0002000	D

Final masterdata account:

IDs	Attribute
CE0004830	A
CE0065000	B
CE0010000	D
CE0002000	E