All queries and USED InfoProviders (query and underlying infoproviders)

[Former Member]

Hello,

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!

Regards, Robin

[Former Member]

If you have turned statistics on, look in your statistics cube and right a report that includes infoprovider and query. If you are in a 3.x system you can write it off of technical cube 0BWTC_C10. I think this cube may be available in some 7.x installations if you choose to install and load it.

Brian

[Former Member]

have a look at table RSRREPDIR... that should get you started