SAP BPC DELTA LOADING ISSUE

[Former Member]

Hi Experts

I am trying to load cumulative balances from data source 0FI_GL_10 to BPC

the flow is 0FI_GL_10>>zzzFIGL_o10>>>>zzzFIGL_C10

i got the correct balances when i run the first load but when i tried delta load method

balances are duplicated

let me explain with  an example

i have GL called 0010001

its balance is 5000 ( first BW load ) in Jan 2014

when i run delta load process in BW

the Balance of the GL looks like below

0010001 5000 $ Jan 2014

0010001 5000 $ Jan 2014

0010001  6000$ Jan 2014

0010001  6000$ Jan 2014

my problem is the that the table does not overwrite the new cumulative balance beside the data is dublicated

so when i load the data to BPC it will be 5000+6000+5000+6000

and if i have choose to replace through the data package , BPC will not be able the last record to be replaced with the old one

so i just need any way to overwrite the new cumulative record on the old one so that i see in the table of the infocube only the below record

0010001  6000$ Jan 2014 ( the newest cumulative balance )

[Former Member]

Hi Elhoussiny,

Your data flow should like this also confirm your dm prompt check the following TASK also exist in the Advance script while generating the standard Data package.

TASK(/CPMB/SOURCE_DELTA_IP,BYPASS_COMPRESS,0)

…

TASK(/CPMB/APPEND_LOAD_DELTA_IP,INFOPROV_INIT_NAME,%INFOPROV_INIT_NAME%)

Khokan

[Former Member]

Hi Awad,

Kindly use DSO to remove Duplicates.........

The process would be like this ..... 0FI_GL_10--->ZDSO----->ZINFOCUBE.....

I hope this will help you when loading Deltas....

Aravind

[Former Member]

Hi,

I am facing similar issue with 0FI_GL_10. Delta records are not coming properly in infocubes.

However I am getting correct values in RSA3. I have done following steps to get delta data.

1) Enabled INITSMU field as "1" for 0FI_GL_10 datasource in ROOSOURCE table

2) Check whether aggregate behavior is maintained for key figures in DSO and infocube.

For BPC we have used 0FI_GL_10 for opening balances and used 0FI_GL_4 for movements.

Please check whether above steps would be useful for you.

Regards,

Venkat