Deleting Query Objects
You have already defined at least one query, or a structure, or a restricted or calculated key figure.
In the SAP Easy Access Menu of the BW system, choose SAP Menu →
Business Explorer →
Delete Objects. This brings you to a selection screen.
Choose the type of object to be deleted (query, structure, restricted key figure or calculated key figure).
Where necessary, restrict your search further, for example, to a certain InfoProvider, to certain technical names or to the last person to make a change..
Choose Execute. You get a list of all query objects that match the selection criteria. The list contains the technical names of the query objects, the name, and the long description of the InfoProvider, for which the objects are defined.
Select the objects that you want to delete.
Choose to select all of the objects.
Option of Deleting Workbooks after Deleting Queries
After you have deleted a query, you can decide whether you also want to delete all the workbooks that contained a query which has now been deleted. All users can delete workbooks from any of their favorites and roles. This means there is no risk of accessing workbooks with deleted queries in.
The query objects you specified are deleted.
Removing Queries from Workbooks