cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Analytis Cloud Model Data Update

GSL_Nishio
Discoverer
0 Kudos

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   
  PostingDateBrandChannelAmount
  2024/2/301#10000
      
 Example After changed   
  PostingDateBrandChannelAmount
  2024/2/3010110000
      
2.Data import job SAC   
 Example Before imported   
  PostingDateBrandChannelAmount
  2024/2/301#10000
      
 Example After imported   
  PostingDateBrandChannelAmount
 unnecessary→2024/2/301#10000
  2024/2/3010110000
      
 Ideal Model condition   
  PostingDateBrandChannelAmount
  2024/2/3010110000

Nishio

Accepted Solutions (0)

Answers (1)

Answers (1)

N1kh1l
Active Contributor

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.

N1kh1l_0-1707038850152.png

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

Hope this helps !!

Br.

Nikhil