Analysis of Statistics Data 

Use

To analyze the statistics data, you have the following options:

●     Using the database tables or the predefined views

●     Using the technical content

●     In BI Administration Cockpit

To analyze the statistics data for selected queries or Web templates, you have the following options:

●     Using the query monitor (transaction RSRT1)

●     Using Bex Web

Features

Database Tables and Predefined Views

The statistics data is distributed across various database tables.

An analysis using two predefined views (RSDDSTAT_OLAP and RSDDSTAT_DM) is therefore the easiest. To do this, use the Data Browser (transaction SM16).

●     The RSDDSTAT_OLAP view contains the data from the events from the areas for the front end and calculation layer of the analytic engine (Front End/Calculation Layer):

Field	Description
SESSIONUID	UID of the user session (a roll area)
STEPUID	UID of user step
HANDLEID	Counter for runtime object
HANDLETP	Type of runtime object
EVENTID	ID (NUMC9) of the event from the RSDDSTATEVENTS table
UNAME	User name
STEPTP	Type of step (RSDDSTATSTEPTP table)
STEPCNT	Ascending count of steps
UTIME	Time (type TIMS) from STARTTIME field
CALDAY	Calendar day (type DATS) from STARTTIME field
RUNTIME	Duration of a step in seconds
INFOPROV	InfoProvider (when valid)
OBJNAME	Name of runtime object (such as query or Web template)
OBJPROP	Properties of the object encoded as CHAR10 Example for queries: ●     Read mode (see RSRREADMODE data element) ●     Mode for data integrity (see RRACTUALDATA data element) ●     Delta cache on/off (see RRDELTACACHE data element) ●     Partition mode (see RRSPPARTIONMODE data element) ●     Cache mode (see RSRCACHEMODE data element) ●     Persistence mode (see RSRPERSISTMODE data element)
STATLEVEL	Statistics detail level (0, 1, 2)
EVTIME	(Net) Runtime of event
EVCOUNT	Counter for this event (not required for all events)
EVENTIDCNT	Number of calls for this event (for internal use only)
STARTTIME	Start time of step in yyyymmddhhmmss,mmmuuun format

●     The RSDDSTAT_DM view contains the data from the events from the area for the aggregation layer and analytic engine:

Field	Description
STEPUID	UID of user step
HANDLEID	Counter for runtime object
HANDLETP	Type of runtime object
DMUID	UIP for the data manager access
ACCESSCNT	Data access counter (such as database, BI accelerator, RFC) during a data manager event
UNAME	User name
UTIME	Time (type TIMS) from STARTTIME field
CALDAY	Calendar day (type DATS) from STARTTIME field
OBJNAME	Name of runtime object (such as query or Web template)
INFOPROV	InfoProviders
PARTPROV	If INPROV is a MultiProvider, PARTPROV specifies the InfoProvider contained in it
AGGREGATE	Technical name of the aggregate or BIA index (if applicable)
TABLTP	Type of fact table (F or E) if InfoCube or aggregate was accessed
TIMEDMPREP	Preparation time of data access, for ACCESSCNT = 0 only, since not parallel
TIMEDMPOST	Postprocessing time for data, for ACCESSCNT = 0 only, since not parallel
TIMEREAD	Data read time (for example, database, RFC)
TIMESID	Time for calculation/determination of new SIDs
TIMENAVATTR	Time for reading master data
TIMEHIERARCHY	Time for hierarchy handling
DBSEL	Number of records read from the database
DBTRANS	Number of transferred records
WP_ID	ID of work process in which the (possibly parallel) data read access was executed
STARTTIME	Start time of step in yyyymmddhhmmss,mmmuuun format

Technical Content

With predefined queries and Web templates for technical content, you can analyze the data from BI query runtime statistics for queries and BI Web applications. The data is stored in the relevant InfoProvider objects for technical content.

Prerequisites for this are that you have activated the technical content (see Installing BI Content) and the BI administrator role is assigned.

BI Administration Cockpit

You can analyze the data from BI query runtime statistics in BI Administration Cockpit based on objects for technical content. 

For more information, see BI Administration Cockpit.

Query Monitor (Transaction RSRT1)

Using the statistics data, in the query monitor, you can perform an ad hoc analysis of the query runtime.

...

       1.      Select the required query and choose  Execute + Debug. The Debug Options dialog box appears.

       2.      Select the indicator for the debug option Display Statistics Data and execute the query.

       3.      When the query is executed and is displayed with the various navigation steps, press F3 (Back).

The Statistic Data for Query Runtime screen appears. The data for the area for the front end and calculation layer of the analytic engine (Front End/Calculation Layer), and the data for the area for the aggregation layer of the analytic engine are displayed on two separate tab pages.

BEx Web

Using the URL parameter "&profiling=x", you can analyze the BI query runtime statistics of a Web template for the administrator in expert mode.

We recommend this setting only if there are problems with the performance of one specific Web template.

For more information, see Display of BI Query Runtime Statistics on the Web.