Skip to Content
author's profile photo Former Member
Former Member

ODS OVERWRITE

Posted on Jun 28, 2004 at 11:09 AM 14 Views

Hi,

I want to overwrite the records in ods by using only two characters,but my ods has 3 characters and 15 key figures. can any one tell me how to do that.

Thanks & Regards,

Ramkumar.

BW (SAP Business Warehouse) SAP NetWeaver Application Server
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Gianfranco Vallese
    Gianfranco Vallese
    Posted on Jun 28, 2004 at 01:15 PM

    Don't know if I understood ... There's no way to "overwrite" ODS data if you only match 2 on 3 Key fields ... at least you should be able to establish a rule to derive the third key field ...

    Hope it helps

    GFV

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Marc Bernard
    Marc Bernard
    Posted on Jun 28, 2004 at 10:50 PM

    Hello Ramkumar,

    there's no standard way of doing this. Here's a solution that worked for one of my customers:

    In the start routine to the ODS, you determine all possible combinations of the two characteristics from the data package. Then use those combinations to read the ODS table and add all records you find to the data package with either a delete indicator of a sign reversal.

    Regards,

    Marc

    SAP NetWeaver RIG, US BI

    Add comment
    10|10000 characters needed characters exceeded