Skip to Content

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.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jun 26, 2019 at 02:37 PM

    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.



    Add a comment
    10|10000 characters needed characters exceeded

    • 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.



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.