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.
The BEx Query Designer provides the following functions:
Restricting characteristics to characteristic values, characteristic intervals, and hierarchy nodes. For more information, seeRestricting Characteristics.
Defining reusable calculated and restricted key figures (seeDefining Calculated Key Figures andDefining Restricted Key Figures)
Using local or reusable structures (seeStructures andCreating Reusable Structures)
The most significant components of the query definition are filters and navigation:
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.
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:
See also: