OLAP Variables in DTP filter

[Former Member]

Hi All,

I need to extract the data records which are older than 1 day(i.e by comparing with sy-datum) to a standard infocube.

Could any one tell me how to use OLAP Variables in DTP filters.

Regards,

Uma

[raju_saravanan · Accepted solution]

Hi Uma

My Suggestion, Use data selection in IP level before loading to PSA.

Than you can straight away execute the DTP.

In IP Using 0CALDAY restrict the load for your requirement (i.e) one day older

Than Execute the DTP

Update me if you had any problem

Regards

Saravanan.ar

[raju_saravanan]

Dear Uma

If you really want to restrcit from DTP,

Use filter option in the DTP. There you can restrict and load the data for your requirement.

Hope this will help you.

Regards

Saravanan.ar