Presentation

In order to delete un-used queries that may polute the system, it is necessary to run a cleaning process from time to time.This is necessary in order to :

• Improve the overall BW performances.
• Improve the experience of the users that will not find useless/test queries when searching.
• Detect applications that are no longer in use.
• Allow deletion of related objects (variables, workbooks...)

General rule

To be deleted queries not used for more than a year

 if you are not sure, do not delete it.

Frequency / Servers

This should be done every 6 months as a minimum and can be run at any time in between.

This has to be run only on the WBP and PQ1 servers.

Procedure

• Launch transaction "RSZDELETE*"
  • Select Type = REP (Query)
  • Select Last Used = Current date to Current Date - 365
  • Technical Name = Exclude range "0*" (Technical Content).
  • Version : All Query Elements
  • Transport System : With transport Connection
  • Dependent Objects : Workbooks, Query Views, BBS Sender/Recipient
• Run the list
• Check the list one by one to select the queries to be deleted.
• Run the deletion (this can take several minutes)

Be careful to select on the column "Delete".  The first column does not consider for this tcode.  For example this screen shot below, it will delete all queries that Deletion flag is selected although he first column is not selected

Please ensure that "Delete" column uncheck for the query that should not be deleted

You can safely delete :

• Test queries : all queries with "test", "TST" etc...
• Queries containing "test" or "tst" or "temp" in description or technical name.
• Copy queries for UR's : Queries with "URxxxx" in the description or technical name (or just the UR number after the technical name).
• Queries with IT member initials in it.
• Super user queries : Technical name starting by "Z".

Exceptions (Do Not Delete Queries): 

To delete queries in these exceptions it is necessary to first analyse the usage case by case. 

All servers

• Technical content queries : technical name starting by 0
• Backup queries : stated in the name or technical name it is a back up query. Ex : _BACK, _BKP, SAVE, _SAUV
• Broadcast queries : all queries which have a name/technical name mentionning broadcasts. Ex : _BCAST, _BC
• APD queries : all queries which have a name/technical name mentionning APD: Ex : _APD.
• Qlikview queries : all queries which contain "QV" in the technical name.
• POC queries : all queries which contain "POC" in the name.

WBP

• GSV Queries : Technical name starting by GSV - For this you need validation from Purchasing Tools team.
• GSV Cockpit queries : Description starting by GSV Cockpit - For this you need validation from Purchasing Tools team.
• Value Stream queries : All queries with "VS".
• Core queries : queries with technical name starting by "BW_QRY" or "RCS_QRY" and that have "Core Query" in the description - For this you need validation from corresponding stream Reporting Process Expert

+ you can check the usage of the query on the 18 months ago to be sure that the queries are not used anymore by someone.

How to check the query deleted by RSZDELETE

Tcode SLG1 and enter object RSZ* 

Note: Basically the RSZDELETE generates logs under object ID = 'RSZ'. Function module 'RSDG_WRITE_PROTOCOL' is used for that.

Result