Functions in the Query Menu

Use

This is an overview of the functions in the Query Designer bar in the Querymenu.

Features

The Querymenu offers the following functions:

Menu: Query

Menu Option	Description
New…	To create a query, choose New... The BEx Open dialog appears. 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. More information:Defining New Queries.
Open…	When you choose 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.
Check	Before saving a new or changed query, you can use the Check function to check the query definition for errors. Whenever you use the Quit and Use Query function, the system calls the Check function automatically for queries that have not yet been saved. Once the system has checked the query successfully, it prompts you to decide whether to save it.
Save	When changing a query, you can use the Save function to save it under its current name. If the query does not have a technical name, the system displays the Save As… function automatically. More information:Saving Queries.
Save As…	To save the query under a new technical name, choose Save As... Enter the new technical name. You can save the query in your favorites or roles. More information:Saving Queries.
Delete	To delete the query, choose Delete. You can delete the query only if it is no longer being used (in any workbook, Web template, report or broadcast setting).
Where-Used Lists	If you want to identify where the query is used, choose Where-Used List. In the Where-Used List screen area, the system displays the objects (workbook, Web template, report, or broadcast setting) in which this query is used.
Documents	This function enables you to access the document browser, where technical information about the query is displayed (technical name, identifier, last changed by, and so on) and you can see all documents for this query. Using the document browser, you can display documents, create a new text document, insert new formatted text, or upload an existing document.
Properties	Choose Properties if you want to change the description of the query or if you want to make settings for the Result Position, Display Options, Value Display, and Suppress Zeros for the query. You can also release OLE DB for OLAP in the query properties. You can also access the existing documents for the objects used in the query from here. The Query Properties dialog box appears in the Properties screen area. You can make the required settings here. More information:Query Properties.
Execute...	Once you have defined and saved your query, you can use this function to display it in BEx Web Analyzer and analyze the data. More information:BEx Web Analyzer.
Publish	You can 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: To Role… The save dialog appears. Here, you can select the role where you want to publish the query. The system saves a link to the current query in the selected role. To Portal… The publish dialog appears. This enables you to publish the query in the Portal Content Directory (PCD) as an iView. More information:Publishing Queries, Web Applications, and Reports. BEx Broadcaster BEx Broadcaster is launched. This is a Web application for precalculating and distributing queries, query views, Web templates, reports, and workbooks. You can precalculate the query that you edited in Query Designer, or generate an online link. You can broadcast the generated document or link by e-mail, print it, or publish it in the portal. More information:Broadcasting BEx Objects.
Exit and Use Query	You can use this function to exit the Query Designer and use the query that you have defined. This function is only available if you have called Query Designer from other BEx tools. The format in which the query is used depends on the tool you called Query Designer with. Generally, the query is available as a data provider for Web applications, reports, or workbooks. If you have not saved your query yet, the system calls the Check function automatically to check the query for errors. Once the system has checked the query successfully, it prompts you to decide whether to save it.
End and Discard Changes	This function is only available if you have called Query Designer from other BEx tools. Using this function, you quit Query Designer but do not use the modified query in the BEx tool from which you called Query Designer. Instead, the version of the query is used that was displayed before you called Query Designer. If you have not saved your query yet, the system calls the Check function automatically to check the query for errors. Once the system has checked the query successfully, it prompts you to decide whether to save it. You can therefore save the query in the new version without using this new version in the current environment (BEx Analyzer or BEx Web Application Designer, for example).
Exit	You can use this function to quit Query Designer if you called it from the start menu rather than from other BEx tools. If you have not saved your query yet, the system calls the Check function automatically to check the query for errors. Once the system has checked the query successfully, it prompts you to decide whether to save it.