Displaying and Changing Existing Queries in the Query Designer

1. You call the BEx Query Designer using one of the following options:
   • Standalone, by choosing Start → Programs → Business Explorer → Query Designer.
   • BEx Web Application Designer:

     In the menu bar of the Web Application Designer, choose Tools → BEx Query Designer.

   • BEx Analyzer:

     If you are already in a cell of the query, in the analysis toolbar, choose Tools → Change Query <Technical Name>. The Query Designer opens with the associated query. In this case, step 2 is omitted (see below).

   • BEx Report Designer:

     In the menu bar of the Report Designer, choose Tools → BEx Query Designer.

2. In the Query Designer menu bar, choose Query → Open.

   The BEx Open Dialog appears. All queries are offered here in your history, favorites, or roles, or are listed according to InfoArea. In InfoAreas, a list of all existing queries is displayed from the BW system that you have display authorization for.

1. Display the query in the Query Designer.
2. You can now make changes in the query definition.The procedure for changing the query is the same as for creating a new query (see also:Defining New Queries).
3. You have two options for saving the query:
   • You can save the changed query. In the Query Designer menu bar, choose Query → Save.
   • You can save the changed query as a new query. In the Query Designer menu bar, choose Query → Save As. . Enter a new technical name, a new short text, and a new description.
4. You can also delete the query. In the Query Designer menu bar, choose Query → Delete.You can delete the query only if it is no longer being used (that is, if it is not being used in any workbooks, Web templates, report, or broadcast settings).

More Information:

Saving Queries

Menu Bar Functions in Query Designer