SAP Analytis Cloud Model Data Update

[GSL_Nishio]

Dear SAP Expert

Data import from SAP Business ByDesign to SAP Analytis Cloud into the model using data sources.

After importing data into SAP Analytis Cloud, Change the document in SAP Business ByDesign and import the data again. SAP Analytis Cloud model must include only changed data, but current configuration includes both pre- and post-change data in the model

Please tell me how to include only changed data in the SAP Analytis Cloud model

Example of Question

1.Change document ByDesign
	Example Before changed
		PostingDate	Brand	Channel	Amount
		2024/2/3	01	#	10000
	Example After changed
		PostingDate	Brand	Channel	Amount
		2024/2/3	01	01	10000
2.Data import job SAC
	Example Before imported
		PostingDate	Brand	Channel	Amount
		2024/2/3	01	#	10000
	Example After imported
		PostingDate	Brand	Channel	Amount
	unnecessary→	2024/2/3	01	#	10000
		2024/2/3	01	01	10000
	Ideal Model condition
		PostingDate	Brand	Channel	Amount
		2024/2/3	01	01	10000

Nishio

[N1kh1l]

GSL_Nishio

The 2 records have different Channel information. Initially it was # and later it was changed to 01. If channel is a dimension in SAC, both these records are independent records as the channel master data is different in 2 incoming records. I am not sure if you have a document number in these incoming records which generally acts like a primary key either alone or in combination with other fields. Either map all channel to 01 or use clean and replace subset of data option and select the document number or other fields which can acts as key and identify the records uniquely and help in clearing the target before the incoming records.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/6aa6a99d4eb5467896c4f...

Hope this helps !!

Br.

Nikhil