Saturday, January 24, 2009

Query Monitor - helpful tool for testing BI queries

Query Monitor is one of the BEx monitor tools that enable to display and verify query correctness, test variants and additional query properties. To use it start RSRT transaction (you do not need BW front end).


I usually use Execute and Execute + Debug options. Execute + Debug option enable for example to check aggregates, set authorization breakpoints, run query with BI Accelerator, display SQL statement for the query and show BW statistics.

You may choose different query display format. BEX Analyser display format is by far the fastest and the simplest, List gives you additional query options and using HTML format you receive portal-like view.

You can also use the tool to check users' authorization to a query. To execute a query as another user start RSUDO transaction and choose a user and a query.

No comments: