Delete multiple reports in one go

[#1]

Hi ,

In my BW systesm , we have lots of Queries which are not used by any users. more than 300 unused reports .

do you know how to delete all reports in quick time ? .

Thanks

pankaj

[former_member345199]

Hi,

Try program COMPONENT_REORG.

Try this in DEV first and then in Prod.

This may work.

Hope this helps.

Thanks,

JituK

[Former Member]

You can do mass deletion of queries in RSZDELETE, use UID of the Element ( Query ID ) with the Multiple Selection feature.

You can even import the names from a text file.

[Former Member]

WHAT DO YOU MEAN BY UID ? HOW TO FIND IT FOR EACH QUERY ?

[Former Member]

You can get the UID from table RSZELTDIR ( Enter Query Tech Name for field Query ) or Metadata Rep or Query Properties ( Advanced - Tab ) .

[Former Member]

Hi,

Try transaction RSZDELETE. Iam not sure whether you can delete multiple queries.

regards,

Murali.