Filter in DTP and IP or not

[Former Member]

Hi there.

I am setting up a new ETL where I need to filter out actuals for some datasources.

I know I can do this in InfoPackage or DTP, but I have a question.

We have experienced trouble when transporting transformations DTPs and IPs.

I feel a bit concerned that we would have to make DTP or IP in the future, and that the filters then will be forgotten.

What is the recommended way of doing this.

[Former Member · Accepted solution]

Hi Ingrid,

I have used restrictions in DTP and they work fine for me. Loosing something in transport is always a concern but if it is tested and well documented then it could work fine. Otherwise you can use start routines, or transformation routines to get rid of the values that you don't need but they are aslo prone to transport errors.

Other way is load everything and then restrict in the reports by not showing actuals etc.

Regards,

Nikhil

[rajkumar_kandula]

Hi,

It is completed depends upon ur scenario.

If u have filters in IP level u r going to filter data before entering into Bi i.e.., ur PSA will contain the filtered data.

If u have filters on DTP then u will be getting the filtered data into ur Data Target and u r having the entiire data inur PSA.

So it is recommedned to have filters in DTP if u r more concerned abt data.

If u concerned abt loadin gperormance it is better to hav them in IP

Regards,

Rajkandula