Skip to Content

How to update few records in infocube?

Hi,

I have to update few records into info cube 0SD_C03 from data sources 2LIS_13_VDHDR and 2LIS_13_VDITM. Records are present in Full Uploaded data source request in PSA.

Kindly provide me a solution.

Regards,

Yogesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 21, 2017 at 04:13 PM

    Hi Yogesh,

    I will assume you are using BI Content unmodified with a direct load from DataSource to InfoCube in a 7.x system.

    Consider creating a one-time-use DTP as a full load with a filter which includes only the records you wish to add.

    Selectively delete the data in the InfoCube, execute the one-time-use DTP, delete the full load PSA request to prevent duplicate records.

    Also consider:

    1) Deleting all data from the InfoCube and reinitializing the delta.

    2) Add a Standard DSO using Billing Document and Item as keys between the 2LIS_13* DataSources and the 0SD_C03 InfoCube.

    Good luck,

    John Hawk

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 08, 2017 at 04:30 PM

    Take Data selection in infopackage or include required records in DTP filter

    Add comment
    10|10000 characters needed characters exceeded