Scribd
Upload
72 views11 pages

Ad Hoc Query Deletion Guide

This document provides instructions for deleting existing ad hoc queries in SAP Business Warehouse/Business Intelligence (BW/BI) using two methods: 1) Deleting individual queries via the BEx Query Designer user interface. 2) Deleting multiple queries at once via the RSZDELETE transaction. It describes the steps to delete queries using each method, including selecting the queries, confirming the deletion, and verifying successful removal. The goal is to help BW/BI power users manage the number of queries they have created by allowing them to delete queries that are no longer needed.

Uploaded by

Mar Kamon
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
72 views11 pages

Ad Hoc Query Deletion Guide

This document provides instructions for deleting existing ad hoc queries in SAP Business Warehouse/Business Intelligence (BW/BI) using two methods: 1) Deleting individual queries via the BEx Query Designer user interface. 2) Deleting multiple queries at once via the RSZDELETE transaction. It describes the steps to delete queries using each method, including selecting the queries, confirming the deletion, and verifying successful removal. The goal is to help BW/BI power users manage the number of queries they have created by allowing them to delete queries that are no longer needed.

Uploaded by

Mar Kamon
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 11

SAP Business Warehouse / Business Intelligence Reporting

Exercise 5 Deleting an Existing Ad Hoc Query


Washington State HRMS Business
Warehouse/Business Intelligence (BW/BI)
BW/BI Power User Workshop Materials
General Topics BW/BI Power Users

BW/BI Power User Workshop Exercise 5

Exercise 5 - Deleting an Existing Ad Hoc Query


It is important that BW/BI Power Users manage the number of ad hoc queries they have created. Ad
hoc queries that are no longer used need to be deleted by the BW/BI Power User that created them.
The following demonstration will show how to delete ad hoc queries:
Delete individual ad hoc queries via BEx Query Designer
Delete multiple ad hoc queries via transaction RSZDELETE
Via BEx Query Designer:

Via transaction RSZDELETE:

Note: BW/BI Power Users can only Edit or Delete ad hoc queries they created (Personal or Agency-specific)

BW/BI Power User Workshop Exercise 5

Exercise 5 - Deleting an Existing Ad Hoc Query


The following demonstration will show how to delete a query using BEx Query Designer
To delete an ad hoc query that has been opened in BEx
Query Designer:
1.

Click the Query options from the BEx


Query Designer menubar.

2.

Select Delete

3.

At the prompt, Query [Query Name] will be deleted.?, click Yes.

BW/BI Power User Workshop Exercise 5

Exercise 5 - Deleting an Existing Ad Hoc Query


Result: The ad hoc query is deleted. The BEx Query Designer screen will be blank.

BW/BI Power User Workshop Exercise 5

Exercise 5 - Deleting an Existing Ad Hoc Query


The following demonstration will show how to delete queries using transaction RSZDELETE

The transaction RSZDELETE allows Power Users to delete unused ad hoc queries they have created.
Once you have logged into the environment that you need to delete queries from, enter transaction
RSZDELETE in the command field and press enter or click the enter icon
:

BW/BI Power User Workshop Exercise 5

Exercise 5 - Deleting an Existing Ad Hoc Query


Enter your selection criteria
and click the Execute icon
.

BW/BI Power User Workshop Exercise 5

Exercise 5 - Deleting an Existing Ad Hoc Query


All the queries Owned by the Userid you entered in the selection screen will be displayed.
They will all be checked in the Delete column, use the Select/Deselect All Objects button
to Deselect all of the queries:

BW/BI Power User Workshop Exercise 5

Exercise 5 - Deleting an Existing Ad Hoc Query


Select the queries you want to delete and then click the Execute icon

BW/BI Power User Workshop Exercise 5

Exercise 5 - Deleting an Existing Ad Hoc Query


The Delete? box will be displayed.
If you are sure you want to delete the selected queries, click the Yes Icon

If you decide that you dont want to delete the selected queries, click the No icon

BW/BI Power User Workshop Exercise 5

Exercise 5 - Deleting an Existing Ad Hoc Query


If the Yes icon was selected, the queries will be deleted and you will get the Log
Display. Click the OK icon
:

BW/BI Power User Workshop Exercise 5

10

Exercise 5 - Deleting an Existing Ad Hoc Query


The RSZDELETE main screen is displayed.

BW/BI Power User Workshop Exercise 5

11

You might also like