Start of Content Area

Component documentation Query Monitor  Locate the document in its SAP Library structure

Purpose

The query monitor tests, checks, and manages BI queries. You use the query monitor to test or regenerate queries and query views, and to check or change query properties.

With the query monitor you have the option of displaying technical information about queries. Furthermore, the query monitor allows entry into the cache monitor.

The query monitor is a transaction for administrators, because previous technical knowledge is presumed.

Implementation Considerations

You can use this component of the BI system without a BW front end. However, you need to have already defined in the BEx Query Designer the BI queries that you want to use.

Integration

You get to the Query Monitor from the Business Explorer SAP Easy Access screen → BEx Monitor → Query Monitor.

Features

Query

Specify the technical name of the BI query that you want to use. Input help is available for searching in History, InfoAreas, Roles, and Favorites.

View

If you want to test a query view, specify the technical name for the query view you want in the entry field. Input help is available.

The following functions are available in the query monitor toolbar:

Pushbutton

Function

This graphic is explained in the accompanying text Execute

Execute the query or query view

A screen with the query display in an HTML control opens. You can test the display functions, with certain restrictions, as you would on the Web.

In the upper part of the entry screen, the URL is displayed with the complete parameterization.

You can use the available pushbuttons to set bookmarks.

This graphic is explained in the accompanying text Generate Report

Regenerates the query code. The code is stored as a generated report.

Note

With a regeneration, the agreement is always given with the query definition

This graphic is explained in the accompanying text Properties

The Query Properties dialog box appears.

For more information, see Query Properties.

This graphic is explained in the accompanying text Messages

The Suppress Messages dialog box appears.

On this screen you can determine which messages for the chosen query are not to be shown to the user in the front end.

In the left-hand screen area you are able to choose the message category, for example, Generating, Hierarchy, Variables, Key Figures, Calculate As. In the right-hand screen area you see those messages you can choose not to display. If you double-click on the short text for the message the system displays the long text for the message in the screen area below.

Put a checkmark in the boxes next to the messages that you want to suppress, and go back. The system saves your entries automatically

This graphic is explained in the accompanying text Generation Log

The Evaluate Application Log screen appears. If the Generation Log option has been activated for the query (see Query Properties) you can display the corresponding generation log after you generate the query.

By using the respective pushbuttons, the following functions are available for selection:

Pushbutton

Function

This graphic is explained in the accompanying text Performance Info

The Performance Info screen appears. The system displays performance-relevant information for the query that do not correspond to the system recommendations (This graphic is explained in the accompanying text). The information refers to the following areas:

Query definition:

Query cannot use aggregates (corresponds to specifications in Technical Information under OLAP-Relevant Data)

●     Read mode X or A (see Read Mode)

Query cannot use the cache (corresponds to specifications in Technical Information under OLAP-relevant Data)

●     Query uses customer exits

There are non-cumulative values with AVI (corresponds to specifications in Technical Information under Non-cumulative Flags)

InfoProvider:

●     InfoProvider is a MultiProvider

●     Database statistics need to be checked

●     Database indexes need to be checked

This graphic is explained in the accompanying text Technical Info

The Technical Information screen appears.

For more information, see Technical Information.

This graphic is explained in the accompanying text Cache Monitor

The Cache Monitor screen appears.

For more information, see OLAP Cache Monitor.

This graphic is explained in the accompanying text Query Variants

If the query contains variables that are ready for entry, the query variants are displayed on the subsequent screen. You can change these or create new variants.

This graphic is explained in the accompanying text Test IGS

Test Internet Graphics Server

With the Internet Graphics Server (IGS) from SAP, you create in the BI system charts and maps for Web-based reporting.

The Test IGS is used to check whether the Internet Graphics Server can be accessed. If the system displays a graphic with two sets of three bars, you have a connection. You can now connect to performance analyses.

For more information, see the implementation guide (IMG) of SAP NetWeaver Business Intelligence under Reporting-Relevant Settings → Web-Based Settings → IGS Settings.

Constraints

The function that provides the BI front end is not entirely supported in the query monitor. On the other hand, there are settings that you can only make here and not in the front end (see This graphic is explained in the accompanying text Properties and Query Properties).

 

 

End of Content Area