Delete Query

[p_m8]

Gurus,

I have more than 350 queries on my old BW 3.5 system. I am planning to do some "system cleanup".

Is there a good way to identify what query has been obsoleted and can be deleted?

How should we delete the query?

Kindly advise, thanks.

[Former Member]

Hi lynn,

You should have activated the BW Statistics standard content!

When you install these Business Content datasources, InfoProviders, ... and you select your InfoCubes to be monitored, a reporting will be available on your system concerning your query usage!

This wil give you a good overview about the queries that are used, on what frequency by which user...

If you still have time you should set it up now, wait a little while, investigate your result and see which queries can be deleted.

Best Regards

[former_member184494]

yu can delete using RSZDELETE as mentioned - but then

"query has been obsoleted" - you would have t find this oout from your system befre you d thi...

[p_m8]

Thanks, so basically we can just delete the query directly in Production. We dont transport this from Dev to QA then Production, correct?

Regarding the "obsolete report", is there any good transaction/report that can tell us what query has not been used for the past 3 months etc? Or what query is not active? Total number of query we have in the system?

Kindly advise, thanks.

[Anand71]

Hello,

You can use following Table :

RSZCOMPDIR

Search also woth RSZ* to get more tables.

Thanks.

With regrads,

Anand Kumar

[p_m8]

What can I tell from this table?

[Former Member]

Hi

use t code RSZDELETE

hopes this helps

santosh