Defining Queries
Use
You define a query that is used as the data provider for the BEx Web application.
Procedure
Starting the Query Designer and Selecting the InfoProvider
...
1. Start the BEx Query Designer by choosing Start → Programs → Business Explorer → Query Designer.
2. Log on to the BI system.
3.
In the toolbar,
choose 
New Query...
4. Choose Find.
5. Enter ZD_SALES as the search string in the upper empty field, select Search in Technical Name and deselect Search in Description.
6. Choose Find.
InfoCube ZD_SALES is displayed in the lower empty field.
7. Select the InfoCube ZD_SALES and choose Open.
The data of InfoCube Sales Overview (ZD_SALES) is displayed in the left part of the InfoProvider screen of the Query Designer.
Defining Characteristic Restrictions in the Filter
...
1. Expand the dimension Time and drag the characteristic Calendar Year/Month to the Characteristic Restrictions with drag and drop.
2. Select Calendar Year/Month and, in the context menu, select Restrict....
The input help dialog for selecting characteristic values with which the query is filtered at runtime appears.
3. Under Show choose Value Ranges.
4. Enter Between as operator and select July 2007 to September 2007 as the interval. To do this:
a.
Call the input help
for the lower value of the interval using the input help 
Select from List.
b. Choose Show → Single Values.
c. Select July 2007 and choose OK.
The lower value July 2007 appears in the first field.
d. Repeat steps a to c for the upper value and select September 1007.
5. To add this restriction to the selection, choose the arrow to the right Move to Selection.
6. Choose OK.
7. Drag the characteristic Calendar Year/Month to the right area Default Values and in the context menu select Restrict...
8. Select September 2007 (which automatically appears in the History) and add the value using the arrow to the right.
9. Choose OK.
The restrictions in the filter have an effect on the entire query. In this case the InfoProvider data is aggregated for the calendar months July 2007 – September 2007. The proposed value is used as an initial value in the initial view (when executing the query or Web application) and can be changed if required. For example, users can display the sales data for July or August instead of September.
Selecting Characteristics and Key Figures for Navigation
...
1. Choose the screen area Rows/Columns.
It is displayed as a tab following the tab Filter at the bottom of the screen area.
2. In the screen area InfoProvider, expand the dimension Sales Organization and drag the characteristic Channel to Rows with drag and drop.
3. In the screen area InfoProvider, expand the dimension Product and drag the characteristic Product Group to Rows (under Channel) with drag and drop.
4. Drag the key figures Quantity and Revenue from the screen area InfoProvider to the Columns with drag and drop.
The key figures are automatically arranged in a structure with the default name Key Figures since key figures are always displayed in a structure for technical reasons. You can change the name of the structure if required by selecting Key Figures and changing the description of the structure in the right screen area Properties.
5. Drag the characteristic Product from the screen area InfoProviders to the area Free Characteristics with drag and drop. (It already automatically contains the characteristic Calendar Year/Month, which you added to the filter.)
The arrangement of the characteristics and key figures in the rows and columns defines the initial view on the data table. You can change it by navigating. The free characteristics can be used for navigation. For example, users can add one of the free characteristics to the table.
Saving Queries
...
1.
From the toolbar,
choose 
Save Query.
2. Enter Sales Summer 2007 as the description and ZD_SALES_2007 as the technical name.
3. Choose Save.
Displaying the Query on the Web (Optional)
To check the data and structure of the query, you can execute the query ad hoc in the Web.
...
1.
From the toolbar,
choose 
Execute... ..
2. Log onto the portal.
The query is displayed in the BEx Web Analyzer. This enables you to perform an ad hoc analysis of the data.
Result
You created the query and can now create the BEx Web application.
Continue with ....