Delta Load

[Former Member]

Hi Gurus,

Another issue, we have a BI system as the source and due to huge data volume we have decided that we will be using a delta mechanism (only changed data is sent). When I use the standard import package there are 2 options

1. Merge data values

2. Replace and clear data values.

Irrespective of the option I select the data gets overwritten in the cube

Eg - original record value 100, changed record is 10 that means add 10 to the original record but after the second load data in the cube becomes 10.

The Append to fact table package works fine so I am able to get by this issue.

The only reason to raise this in the forum is to check if there's an issue with import package (or there's another setting to make delta work) or it works as designed.

thanks

[JHattendorf]

Anand - the Import package is working as expected. It first determines the total value for each unique intersection in the data to be loaded. It then compares that value to the total for the same intersection (of dimension members). Finally, it books an adjusting entry in BPC so that the new BPC total is equal to the value in the data set that is being loaded.

Cheers,

Jeff

[Former Member]

This works as desired. By default there is not delta lead mechanism in the standard import packages of SAP PBC.

-The replace and clear is clearing the whole category/time/entity combination that you try to load. so works fine if you have 1 datafile per entity.

-the merge adds data for different intersections of the same category/time/entity combintion.

So for example if you have 2 datafiles, a P&L and a Balance sheet datafile for the same category/time/entity combination, and load first the P&L and secondly the Balance sheet file. The replace and clear would end up with only the balance sheet values (because it overwrites the previously loaded P&L data for the same category/time and entity.

While the replace and clear adds the balance sheet data for the same category/time entity combination next to the existing P&L data of the first load.

Hope this makes it more clear for you.

Joost