Query as Infoprovider - filtered by DTP

[marcelo_santosbueno2]

Dears, we have a query as infoprovider and we would like to use for more than one Organization. So, we decided to filter it at DTP (We created 3 DTPs, each one with a organization filtered).

How that filter is going to work?

- Query will be executed first before any filter and than apply DTP filter

- BW will create a MDX statement or something already calling the query to be executed with filter

I hope second option. I will try to debug later and see if I can find something. Just checking if anybody knows already.

Thanks!!

Marcelo

[marcelo_santosbueno2 · Accepted solution]

Debug done and actually it is using exactly same class used to read Infoprovider. It is passing all the filters from DTP to O_T_RANGE table.

Regards,

Marcelo

[former_member586947 · Accepted solution]

Hi Marcelo,

What about the static filters/customer exit variables used at the query level? Does it take the filters from DTP and filters from Query to read data from infoprovider? or whole data will be read from the infoprovider and then the filters applied?

Could you please elaborate your debug results, so that we can understand the functionality in detail.

Regards,

Satya

[mifo · Accepted solution]

Had the same question today. So it is the variant 2 (better), correct?

Thank you!

[mifo · Accepted solution]

Hi Marcelo,

can you also tell me what class it is?

We are having the issue that a query (used as infoprovider) in a transformation returns different decimal values compared to the direct execution via rsrt for example and I would like to debug the class you mentioned.

Thank you!

Best regards,

Michael

----

Found it. It is CL_RSDRI_INFOPROV used in CL_RSDD_X_QPROV_CMD.