Menu Entry

Description

New Query

If you want to create a query, choose New Query. The BEx Open dialog appears, where you can select the InfoProvider whose data you want to use as the basis for your query. You can select the InfoProvider either from the InfoProviders in your history or from the list of all available InfoProviders under InfoAreas. See Defining New Queries.

Open Query

The BEx Open dialog appears when you choose Open Query. Here, all existing queries are available in your history, favorites, roles or listed according to InfoArea. In InfoAreas, you get a list of all existing queries in the BI system for which you have display authorization.

Check Query

Before you save a new or changed query, you can check the query definition for errors using the Check Query function.

When you use the function Quit and Use Query, the system calls up the Check Query function automatically for queries that have not yet been saved. Once the system has checked the query successfully, it asks whether you want to save the query.

Save Queries

You can save a query that you have changed under its current name using the Save Query function.

If the query does not have a technical name, the system offers the Save Query As... function automatically. See Saving Queries.

Save Query As...

If you want to save the query under a new technical name, choose Save Query As... Enter the new technical name. You can save the query in your favorites or roles. See Saving Queries.

Delete Query

Select Delete Query, if you want to delete a query. You can only delete the query if it is no longer being used (in any workbook, Web template, report or broadcast setting).

Query Properties

Choose Query properties, if you want to change the description of the query, or make settings for the result item, display options, number display and zero suppression of the query. You can also release OLE DB for OLAP in the query properties. You can also reach any available documents on the objects used in the query from here. The Query Properties dialog box appears in the Properties screen area and you can make the required settings. See Query Properties.

Display Query on the Web

When you have defined and saved your query, you can use this function to display it in the BEx Web Analyzer and analyze the data. See BEx Web Analyzer

Publishing

You are able to publish queries that you have edited and saved in the Query Designer so that they are available to other users.

You can choose from the following options:

In Role

The save dialog appears and you can select a role in which you want to publish the query. The system saves a link to the current query in the selected role.

To the Portal

The Publish dialog appears, which enables you to publish the query in the Portal Content Directory (PCD) as an iView. For more information, see Publishing Queries, Web Applications and Reports.

BEx Broadcaster

The BEx Broadcaster, a Web application for precalculating and distributing queries, query views, Web templates, reports and workbooks, appears. You are able to precalculate the query that you edited in the Query Designer or you can generate an online link. You can broadcast the generated document or link by e-mail, print it, or you can publish it in the portal. For more information, see Functions of the BEx Broadcaster.

Exit and Use Query

You can use this function to leave the Query Designer and to use the query that you have defined. This function is only available if you have called the Query Designer from other BEx tools. The format in which the query is used depends on the tool that you called the Query Designer from. Generally, the query is available as a data provider for Web applications, reports or workbooks.

If you have not yet saved your query, the system calls the Check Query function automatically to check the query for errors. Once the system has checked the query successfully, it asks whether you want to save the query.

Exit and Discard Changes

Choose this function if you want to leave the Query Designer. Your entries will not be saved.