Question:
Hello All,
I have created a new ODS and infocube for sales order data. The ODS and Infocube store sales document and line number information. In ODS update rule, should I use overwrite option for key figures or addition? The key figure aggregation option is set as “summarization”.
My end objective to store the updated/latest sales order item quantity and amount in Infocube. Suppose an order was enter yesterday with quantity 10 and was changed today to quantity 5. My sales order Infocube should now display quantity 5 for this order.
I did a test using both overwrite and addition and it worked fine with both options.
Thanks
Ravi1
Answer:
It depends on the data in R/3. If you have inversion flag ticked in your datasource then you can safely have overwrite in your ODS and addition in the cube.
Answer:
it all depends on the DELTA that your DataSource is delivering....
For example: your sales order changes from 10 pieces to 8 pieces... what kind of delta does your DataSource brings in?
* 1 line with -2 (additive delta)
* 1 line with +8 (after image delta)
* 1 line with - 10 and 1 line with +8 (before and after image delta)
Case 1, your need "addition" in your update rules,
Case 2 and 3, you need "overwrite"
To check: look at the ROOSOURCE-DELTA field for your DataSource (in R/3), then check in RODELTAM what this exactly means...
Answer:
Thanks Guest,
The inversion flag is set for all key figure. So I am safe to use overwirte.
Thanks TFR,
We are only selecting after image record by using userexit. Below is code which only select after image record.
WHEN '2LIS_11_VAITM'.
LOOP AT C_T_DATA INTO WA_MC11VA0ITM.
Z_HOLD_INDX = SY-TABIX.
IF WA_MC11VA0ITM-ROCANCEL = ' '. "after image only
I did not find the ROOSOURCE-DELTA field for 2LIS_11_VAITM. I was looking this field using RSA6. Can you tell some more on this?
Thanks
Ravi1
Answer:
We are only selecting after image record by using userexit. Below is code which only select after image record.
WHEN '2LIS_11_VAITM'.
LOOP AT C_T_DATA INTO WA_MC11VA0ITM.
Z_HOLD_INDX = SY-TABIX.
IF WA_MC11VA0ITM-ROCANCEL = ' '. "after image only
Ok, then off course your Update Rules should be set to overwrite
I did not find the ROOSOURCE-DELTA field for 2LIS_11_VAITM. I was looking this field using RSA6. Can you tell some more on this?
Sorry for not being clear: i meant field DELTA in table ROOSOURCE. With the value you find in there you can read table RODELTAM to find the delta that the DS delivers...
(But off course, you don't need to do this anymore since you know you have the afeter images)