cancel
Showing results for 
Search instead for 
Did you mean: 

Query as Infoprovider - filtered by DTP

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

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

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
Contributor
0 Kudos

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
Participant
0 Kudos

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

Thank you!

mifo
Participant
0 Kudos

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.

Answers (1)

Answers (1)

0 Kudos

Hello Michal, class I found during debug is: CL_RSDRI_INFOPROV (as you got it)

You can include a break-point on READ method. In my case was just to confirm additional filters were passed fine and it was as expected, I saw it on O_T_RANGE. You execute DTP with break point before extraction.

Hope it helps, your situation is a bit different.

Regards,

Marcelo