Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 02, 2008 at 04:11 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi...

      1)First you run Full Upload from ODS to Infocube

      2) Then run Init without data transfer

      3) Then Delta upload..

      Hope this helps you..

      Regards,

      debjani..

  • avatar image
    Former Member
    Sep 02, 2008 at 10:53 AM
  • avatar image
    Former Member
    Sep 03, 2008 at 07:48 AM

    Ok thank you everyone problem solved

    Add comment
    10|10000 characters needed characters exceeded