Selective Deletion and Reloading of the same data in Inventory Cube

[Former Member]

Hi! Experts,

After having selective deletion in Inventory cube based on Plant, Storage Location and Material criteria,

how the same combination (Plant, SLOC,Material) can be reloaded from ECC to Infocube.

While filling up the setup table, we have pulled the data based on posting date for 6 months.

Now how can we extract the deleted record combination from filled setup table data??

Any Ideas or suggestion??

Thnaks,

Sumit

[former_member182196]

In a simple words you can filter data at info package level.

regards,

sm

[RamanKorrapati]

Hi Sumit,

setup tables you can fill with possible selections, while loading into psa, at info pack level you use selections on plant, storage loc and material. as my guess you may don't have selection on plant, storageloc and material, but we can make them for selections by using small program at ecc side.

Thanks

[Former Member]

HI! Raman,

We have checked our info package selection criteria,

It has plant,material,posting date in it.

How can we apply these selection on ECC Side??

Thanks

[RamanKorrapati]

Hi Sumit,

am saying just fill your setup tables with possible ways.

please let us know what selections are possible to fill setup table check thru setup table fill screen.

once you filled them then we load into psa with required selections.

Thanks

[Former Member]

HI! Raman,

We have material document no and posting data as filter criteria.

We have loaded the setup table using posting period for required date.

Now my doubt is how can we filter that data into cube with plant,material,storage location,posting period wise as filter.

[RamanKorrapati]

mean filling setup tables no issues. am i right. need selection to load data into psa and cube.

[Former Member]

yes..Raman..how to filter data into psa and cube.

[RamanKorrapati]

Hi,

just need load up to psa only. next delta dtp(no filters) will take care from psa to further targets.

Write below code at SE38, ecc side.

REPORT  ZTEST.

Tables: ROOSFIELD.

SELECT SINGLE * FROM ROOSFIELD WHERE OLTPSOURCE = '<data source name>' AND

OBJVERS = 'A' AND FIELD ='<field name>'.

IF SY-SUBRC = 0.

ROOSFIELD-SELECTION ='P'

MODIFY ROOSFIELD.

ENDIF.

above code is useful to make particular field for selection at info pack level. in your case assume as MATNR not available for selection at info pack. so you can pass MATNR name at field name place and check it.like that way you can do the code for fields which want selection at info pack level.

Thanks

[former_member182196]

In PSA data selection tab you can filter data and in cube at DTP level, Extraction tab filter option is there.

Just below this screen for PSA and DTP Filter.

PSA Filter -

DTP Filter

Regards,

SM

[RamanKorrapati]

Hi SM,

once we loaded data to psa with proper selections then delta dtp will load the latest request to targets. so filter may not be required at dtp.

Thanks