How to find the list of all queries on each and every cube in the system???

[Former Member]

Hi All,

I need some method to get all the reports(queries)(technical name and description),run on all the infocubes in the system. The number is very huge...roughly...on each cube there are near about 40-50 reports and the number of cubes is also too high.

Is there any table or function moudle which can make this job easy and less time consuming.

Freinds I need this solution urgetly. Please rush back...

regards,

minal

[Former Member · Accepted solution]

Hi Minal,

RSZCOMPIC table lists queries built on the cubes.

COMPUID is an ID of the query.

RSZELTDIR table contains description of the reporting elements. DEFTP field equals “REP” designates queries.

Search for RSZELTDIR-ELTUID = RSZCOMPIC- COMPUID. Field MAPNAME will contain a tech name of the query and TXTLG field – its description.

Best regards,

Eugene

[Former Member · Accepted solution]

Thanx alot Eugene.

This made my work easy...this was about cubes but one more thing I wanted to know,if you could tell me...is there any table from which wewill know the queries written on ODSs as well???

hope to see your reply.

Thanks & Regards,

Minal

[Former Member · Accepted solution]

Hi Minal,

For ODSs you can use the same table: RSZCOMPIC.

Best regards,

Eugene