Solved: Update from ODS to infocube.

Former Member · ‎09-02-2008

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 · ‎09-02-2008

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

Former Member · ‎09-03-2008

Ok thank you everyone problem solved

Former Member · ‎09-02-2008

Hi,

For advantage of LO over LIS, go through this thread

Full request

Update from ODS to infocube.