Entering content frame

Procedure documentation Displaying and Changing Existing Queries in the Query Designer Locate the document in its SAP Library structure

Displaying Queries

       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. Here, all existing queries are available in your history, favorites, or roles or are listed according to InfoArea. In InfoAreas, you get a list of all existing queries in the BI system for which you have display authorization.

Changing Queries

...

       1.      Display the query in the Query Designer.

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).

       2.      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.

       3.      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).

See also:

Saving Queries

Functions of the Menu Bar in the Query Designer

 

 

 

Leaving content frame