How to view list of queries

[Former Member]

Hi,

I would like to see a list of all the queries and the cube on which the query was built on. Is there a table where this information is available in BW? Or, whats the best way to get it.

Thanks a lot

John

[Former Member · Accepted solution]

Hi John,

the table is the RSRREPDIR, Directory of all reports.

Hope it helps.

Bye,

Roberto

[Former Member · Accepted solution]

Roberto,

Thanks for the reply.

But this table lists all the queries. I would like to see only the queries which are active in the system, rather than all the queries delivered.

Even restricting by several fields didn't help. For example on the cube 0SD_C03, we have only 3 queries in the system. But, this table returns 58 entries.

Thanks

Gova

[Former Member · Accepted solution]

John,

OBJVERS 'A' and 'D' give the infos you needed !

If you restrict the selection for 'A' you will see all (only) the active queries ! Or do you want to see only the custom ones ?

Roberto

[Former Member]

The Tech Content cubes have some queries that provide this info, but if you don't need to go back beyond a couple of months or need to see 30 days of daily data, transaction ST03 (in Expert Mode) looking at the BW System Load info is great as far as seeing what queries are actually being used. It provides 3 time ranges -

Today and two previous days.

This week and two previous weeks.

This month and two previous months.

It provides InfoProvider, how often it is queried, DB and OLAP performance info (avg time, rows selected and xfered, etc) and you can then drill on it to see the actual queries that are being run and all the other info mentioned above.

[Former Member]

Hi,

Another way to display all active queries assigned to cubes/MultiProviders is to go to transport connection (rsa1) and then from menu chose Goto --> Where-used list and then pick your InfoProvider. You will then see all created queries and assigned workbooks. You are also able to see structures with assigned queries

/Magnus

[Adem_Baykal]

Hi John,

a good way is also to use the Metadata Repository.

Just use transaction "RSA1" and then select "Metadata Repository" on left side. There you can see all active objects generated in bw. If you like you can see all active queries. If you want to see only queries from a specific info cube just select the info cube and then you will find a list with all active queries based on this cube etc.

Regards,

Adem