Navigation Functions in the Standard Web Template 

Use

When you display a query on the Web, the query is embedded automatically into a standard Web template. The query is displayed on the Web in a table with a navigation block. The name of the query appears as the title. The most commonly used functions are accessed from a toolbar that is embedded automatically. The navigation options are also available in the navigation block and in the context menu.

Integration

You can call up queries on the Web using the following tools:

Query Designer: By clicking on the symbol  Display Query on the Web (see also: Functions of the BEx Query Designer.

BEx Analyzer: By choosing Tools ® Launch in Web Browser: Query (Default View) (see also: Tools).

Ad-hoc Query Designer: If you do not specify the optional attributes DISPLAY_DATA_PROVIDER, TARGET_FRAME and TARGET_TEMPLATE_ID, the query results are displayed in a new browser window in the standard Web template. (See also: Ad-hoc Query Designer.)

You specify the standard Web template in the SAP Reference IMG ® Business Information Warehouse ® Settings Relevant for Reporting ® Web-Based Settings ® Determine Standard Web Template. The 0Query_Template is the default standard Web template. This standard Web template contains the toolbar described below. You can modify the Web template and make this new Web template the standard Web template. See Structure of the Standard Web Template.

Features

In addition to navigating in the context menu and in the navigation block, Web applications that use the standard Web template also have a toolbar containing various functions.

 

 Table

Once you have displayed your data using one of the functions described below, you can use the Table function to display the data as a table again.

 Bar chart

This function displays the query data in a bar chart.  If you want to return to the table display, click on the  Table icon.

 Pie Chart

This function displays the query data in a pie chart.  If you want to return to the table display, click on the  Table icon.

 Line chart

This function displays the query data in a line chart.  If you want to return to the table display, click on the  Table icon.

 3D Bar Chart

This function displays the query data in a 3D bar chart.  If you want to return to the table display, click on the  Table icon.

 Swap Axes

You use this function to swap the axes of the query. For example, if you have characteristics displayed in the rows and key figures in the columns and you choose the Swap Axes function, the key figures are moved to the rows and the characteristics are moved to the columns. If you want to undo this step and switch the axes back to how they were originally, click on Swap Axes again.

 Info

Information about the query key date, how up-to-date the query data is, who last changed the query, when the query was last changed and the last time the query was refreshed is displayed here. You can also see information about the values in the filter and the variable values with which the query is filled.

If you want to return to the table display, click on the  Table icon.

 Exceptions

You can create new exceptions and change or delete existing exceptions. The existing exceptions are displayed along with their status (active, inactive). In the context menu of an exception, you can deactivate, change, or delete the exception. If you want to display the exception in the table, click on the  Table icon.

For more information, see Defining and Changing Exceptions.

 Conditions

You can create new conditions and change or delete existing conditions. The existing conditions are displayed along with their status (active, inactive, not applicable, not used). In the context menu of a condition, you can deactivate, change, or delete the condition. If you want to display the condition in the table, click on the  Table icon.

For more information, see Defining and Changing Conditions.

 Display Variable Entries

If the query contains variables, you can use this function to display the screen for variables so that you can select additional variable values as required. For more information, see The Variables Screen.

 Query Designer

You can call up the Ad-hoc Query Designer and define new queries or change an existing query on the Web. For more information, see Functions of the Ad-hoc Query Designer.

 Bookmark

You can set a bookmark that enables you to call up a certain navigational state for the query at a later date. The system creates a URL for the bookmark. This URL is displayed in the address line of your Web browser.

To enable you to access the bookmark again later, you save the URL in your favorites or copy and paste it into other files.

For more information, see Setting a Bookmark.

 Export to MS Excel 2000

You can export query data to MS Excel 2000.

The query data is displayed in the same way as queries are displayed in the BEx Analyzer. You see the filter restrictions and the data in the table. Exceptions are highlighted in color in the same way as they are on the Web.

The formatting is transferred, but it is no longer possible to navigate using the BW functions. However, you can continue to edit the query using the MS Excel functions.

 Export to CSV

You can export the query data into a CSV (comma separated value) file.

Unlike exporting to MS Excel 2000, you do not see the numbers in context and you cannot see the filter data.  The query formatting (such as how the exceptions are displayed) is also not transferred to the CSV file.