Deleting Query Objects 

Prerequisites

You have already defined at least one query, or a structure, or a restricted or calculated key figure.

Procedure

  1. From the main menu, choose Business Explorer ® Delete Query Objects . This brings you to a selection screen.
  2. Choose the type of object to be deleted (query, structure, restricted key figure or calculated key figure).
  3. Where necessary, restrict your search further, for example, to a certain InfoCube, to certain technical names or to the last person to make a change..
  4. Choose Execute. You get a list of all query objects, which match the selection criteria. The list contains the technical name of the query objects, the name, and the long description of the InfoCube, for which the objects are defined.
  5. Choose Continue, if you want to delete all the query objects in the list. It is not possible to delete individual objects in this dialog window.

If you just want to delete individual query objects, you must either cancel, or make more precise restrictions in the selection screen.

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 in any of their favorites and roles. This means there is no risk of accessing workbooks with deleted queries in.

Result

The query objects you specified are deleted.

See also:

Removing Queries from Workbooks