on 09-02-2015 1:51 PM
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 )
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.