on 2004 Oct 07 7:13 PM
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
Hi John,
the table is the RSRREPDIR, Directory of all reports.
Hope it helps.
Bye,
Roberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
62 | |
12 | |
7 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.