cancel
Showing results for 
Search instead for 
Did you mean: 

How to update few records in infocube?

sunil_hirgude2
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

john_hawk
Active Contributor
0 Kudos

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

sunil_hirgude2
Explorer
0 Kudos

Hi John,

Thanks to reply...

Actually, 8 doc number are present in full load request of PSA, which are not extracted to Info Cube due to some routines in the transformation between the data source and Infocube. Currently, delta load is working fine with the cube. But how to extract those particular records into info cube. So should I need to use the filter in DTP for extraction?

Regards,

Yogesh

former_member186445
Active Contributor

create a full dtp and set the 8 documents in the filter. this should do the trick.