Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Update from ODS to infocube.

Hello gurus,

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.

Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question