Show TOC

BEx Query DesignerLocate this document in the navigation structure

Use

You analyze the dataset of the BI system by defining queries for InfoProviders using the BEx Query Designer. By selecting and combining InfoObjects (characteristics and key figures) or reusable query elements (such as structures) in a query, you determine the way in which you evaluate the data in the selected InfoProvider.

Features

The BEx Query Designer provides the following functions:

The most significant components of the query definition are filters and navigation:

  • The selections in the filter restrict the whole query. When defining the filter, select characteristic values from one or more characteristics or from a key figure. All of the InfoProvider data is aggregated using the filter selection of the query.
  • For the navigation, select free characteristics and define the content of the rows and columns of the query. You use this selection to specify the data areas of the InfoProvider through which you want to navigate. The arrangement of row and column content determines the initial view for the query.

    After being inserted into a workbook, a query is displayed in the default initial view in the portal or in the BEx Analyzer. By navigating through the query, you can generate different views of the InfoProvider data: You do this by dragging one of the free characteristics into the rows or columns of the query, for example, or by filtering a characteristic according to a single characteristic value.

Query definitions allow the InfoProvider data to be evaluated specifically and quickly. The more detail you use to define the query, the quicker its execution and navigation.

Activities

To open the Query Designer, choose Start → Programs → Business Explorer → Query Designer.

You can also call the BEx Query Designer from the following BEx tools:

  • BEx Analyzer
  • BEx Web Application Designer
  • BEx Report Designer

See also:

Defining New Queries