!--a11y-->
Query Monitor 
You can use this component from the BW system without a BW front end. However, a prerequisite would be that you have already defined the BW queries you want in the BEx Query Designer.
You get to the Query Monitor from the Business Explorer SAP Easy Access screen ® BEx Monitor ® Query Monitor.
Specify the technical name for the BW query you want in the entry field. 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 |
|
Execute the query or query view You arrive in a screen with the query display in an HTML control. You can test the functions with certain restrictions in the display as you would on the Web. In the upper part of the entry screen, the URL is displayed with the complete parameterization. By using the respective pushbuttons, you can set bookmarks |
|
Regenerates the query code. The code is stored as a generated report.
With a regeneration, the agreement is always given with the query definition |
|
You arrive at the query properties dialog box. You can find additional information under Query Properties. |
|
You arrive at the Suppress Messages dialog box. In 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. Set the indicator in the ready for input field for the message that you want to suppress, and go back. The system saves your entries automatically |
|
You get to the Evaluate Application Log screen. 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 |
|
You
get to the Performance Info screen. The system displays performance-relevant
information for the query that does not correspond to the system recommendations ( 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 |
|
You arrive at the Technical Information screen. You can find additional information under Technical Information. |
|
You arrive at the Cache Monitor screen. For more information, see OLAP Cache Monitor. |
|
If the query contains variables that are ready for entry, the next screen displays the query variants. You can change these or create new variants. You
can find additional information about query variants under |
|
Test Internet Graphics Server With the Internet Graphics Server (IGS) from SAP, you can create charts and maps in the BW system for Web-based reporting. By using Test IGS the Internet Graphics Server is checked to see whether it 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. You can find additional information in the implementation guide (IMG) for Business Information Warehouse under Reporting-Relevant Settings ® Web-Based Settings ® IGS Settings. |
The
function that provides the BW 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
Properties and
Query Properties).
