Skip to Content
0

How to update few records in infocube?

Feb 20, 2017 at 12:01 PM

85

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

John Hawk Feb 21, 2017 at 04:13 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

1
sudhakar kotha Mar 08, 2017 at 04:30 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded