Hello,
1. I upload a InfoCube in Delta Mode.
2. I upload form this InfoCube to a ODS in Full Mode.
Exemple :
1. InfoCube (Upload in Delta Mode) :
Request Order Operation WorkCenter Values
1 10 1 AAA +10
2 10 1 AAA -10
2 10 1 BBB +20
2. ODS (Upload from the cube above in Full Mode)
Order(key) Operation(key) WorkCenter Values
10 1 AAA -10
The last record upload in my ODS is the second of the Infocube. The data in my ODS are incorrects. I don't know if I need to use 0RECORDMODE.
Thanks in advance for your help.
Stéphane
Hi Stephane,
I do not understand why you're proceeding in such a way; for the usual method consists in delta-uploading into an ODS, then updating into an InfoCube.
Perhaps, you could explain your business scenario?
Best regards,
Laurent Querella
Hello Stephane,
In your scenario, please do either one from following in order to update date correctly in ODS from infocube,
1. Change the update type to an addition from an overwrite at ODS level.
2. or use serialized V3 update at the r/3 side, so that R/3 system sends changed records in the same sequence as it was generated. Because you might be getting +20 first then -10 and ODS setting is kept overwrite. As a result, the ODS data are incorrect(-10).
Hope it helps you.
Thanks and Regards,
~Ketan Patel.
Add a comment