All queries and USED InfoProviders (query and underlying infoproviders)
How can I automatically generate a list of all queries (that run on multiproviders) and the underlying InfoProviders (i.e. contained in the MultiProvider) that are actually used by each query?
For each single query I know how to get the answer to the question: goto RSRT (Query Monitor), choose query and press Execute + Debug. Next, check the box ´_MultiProvider Explain_´ and run the query. Input the required variables and a report will show.
This report includes lines on the underlying InfoProviders of the MultiProvider.
When an underlying InfoProvider is used, it says:
MultiProvider MCO_DMOD1: InfoProvider ZIM_FA_1 ***
list of elements that are queried... **
When an underlying InfoProvider is NOT used by the query, it says:
MultiProvider MCO_DMOD1: InfoProvider ZPS_WBS3 ***
Access to ZPS_WBS3 was excluded
So now I have the InfoProviders that are actually used by the query.
I need this information for ±1100 queries, and therefore, I need a way to get this information automatically.
Please help! Answers are greatly appreciated in terms of points!
Thanks in advance!