Query runtime statistics

Analysis supports the query runtime statistics of SAP NetWeaver BW. You can activate the query runtime statistics in the User Settings dialog box on the Support Settings tab with the Enable Workbook Profiling setting or with the file system setting Profiling in the Ao_app.config file.

Using the query runtime statistics, you can find out how much time the execution of certain user actions require in Analysis and in the BW analytic engine. The system records the performance-critical parts of the processing (statistics events). It calculates the net times by calculating the runtime of an event using the difference between the start and end times (minus the times for other events called from within the event).

Each Analysis workbook has its own connections to the BW system. When the user closes a workbook, the connection to the BW system is also closed. The first workbook - for which a connection to a BW system is opened - shares its connections with the open services of Analysis. This means that the Insert Data Source dialog box reuses the connection from the first workbook.

The first connection to a BW system in a workbook is the “master” connection. The query runtime statistics for Analysis use the BW system of this master connection as the master system.

With the query runtime statistics activated inAnalysis, all events raised by the BI consumer services client code and by the ABAP server code are written to the statistics tables of the BW system. Analysis also raises a small additional set of events, which facilitates analysis of the other events.

If the Analysis events should be written to the RSDDSTAT_OLAP view (transaction code SE16), which contains the data from the front end and calculation layer events, they need to be in table RSDDSTATEVENTS as well. For more information, see SAP note 1462547.

The table below provides an overview of the Analysis events:

Event ID	Long Text	Description
20001	Net Application type	Type of .NET application (objnm is PIONEER EXCEL for example)
20002	Net Scenario	Scenario type of .NET application (refresh for example)
20003	Net Document ID	Document ID of a .NET application (only one per session)
20010	Command	Describes what the user did in the step.
20200	User at dialog	The user waits at a dialog or does actions that return quickly.

Most user actions in Analysis will write an entry with event 20010. The time a user spends on a dialog during execution of the command and not executing another command will be made visible with event 20200. Each start of a statistic session will also contain events 20001, 20002 and 20003.

You can check the statistics in theAnalysis ribbon Actions group under Start of the navigation path Messages Next navigation step Show Workbook Profiling Statistics... End of the navigation path . The Messages entry is enabled only if statistics are available.

For more information about the query runtime statistics, see SAP Help Portal at http://help.sap.com Start of the navigation path SAP NetWeaver Next navigation step SAP NetWeaver by Key Capability Information Integration by Key Capability Business Intelligence BI Platform OLAP Performance Optimization BEx Monitor BI Query Runtime Statistics End of the navigation path .