BEx Query Designer 

Use

Query Designer is a desktop application for creating queries, and plays an important role in the Business Explorer Suite. The queries created can be displayed as data providers for Web applications, reports, and workbooks or can alternatively be displayed in BEx Web Analyzer.

This section describes the appearance of Query Designer and explains how you can customize it according to your requirements.

Features

As well as the menu bars and toolbars, BEx Query Designer comprises the following screen areas:

●      InfoProvider

●      Rows/Columns

●      Filters

●      Tasks

●      Properties

●      Messages

●      Where-Used List

●      Documents

●      Cells

●      Exceptions

●      Conditions

For more information about the screen areas, which you can also display using the menu bar and the View toolbar, see Menu Bar Functions in Query Designer.

You can personalize the appearance of Query Designer.

●      When you start Query Designer, a standard view is displayed automatically. This shows the InfoProvider screen area on the left, the Filter area in the middle, and the Rows/Columns area underneath as a tab page. The Properties area is shown on the right, and the Tasks area is displayed underneath as a tab page. In the lower area, the Messages area is displayed in collapsed form. If you drag the cursor over the Messages area, it expands automatically.

●      You can use the View menu to show and hide screen areas such as Properties or Messages, as well as the toolbars.

●      You can move the toolbars to any position. Depending on where you position the object, it is either anchored or appears as a hovering toolbox. The screen areas can be arranged on top of one another as tab pages.

●      Using the View → Predefined → Standard View menu option, you can return to the standard view. If you prefer to use the view you are familiar with from Query Designer in SAP BW 3.x, choose View → Predefined → SAP BW 3.x View.