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