Update from ODS to infocube.
I am working with the following scenario:
I am planning to report on infocube 0sd_c03. This cube will receive orders just from 2lis_11_vaitm and 2lis_11_vahdr.
I am planning to schedule init load and activate the the delta queue to collect the new and modified orders in BW.
This delta records should pass through the 0sd_o03 where modified orders will overwrite old records.
The question is if there is any method to substitute the old records in the cube with the updated ones without having to delete the whole cube??
Thankx in advance.
Once a record is in a cube it cannot be overwritten.
Instead you either:
- delete all records in cube and rebuild from ODS
- use a delta from ODS to update cube
The ODS will calculate the delta needed to update the cube if values in the ODS are overwritten.
For example if there was just one record in SAP R/3:
In SAP R/3 Order Value £10
Extract from SAP R/3 contains £10
In SAP BW ODS One record value £10
In SAP BW Cube One record value £10
And then the record in SAP R/3 is changed to £11
In SAP R/3 Order Value £11
Extract from SAP R/3 contains £11
In SAP BW ODS One record value £11
Delta calculated by ODS giving +£1
In SAP BW Cube Two records value £10 and £1 giving total of £11