Child pages
  • The Statistics Workbook
Skip to end of metadata
Go to start of metadata

For analyzing a performance issue in BEx Analyzer 7x it is necessary to create a Statistics Workbook first of all.With the Statistics Workbook you can identify the time consuming events while query/workbook processing in BEx Analyzer 7x.This page describes how the Statistics Workbook can be recorded and you can find information about Frontend related statistic events and their optimization. Please also review wikipage Optimizing BEx Analyzer 7x Performance - NEW.

 

In case you get the error IINSTANTIATE_QUERYDEF in class CL_RSROA_VQ_METADATA while displaying the Statistics Worbook please implement relevant note:

A - Create a Statistics Workbook

The creation of a Statistics Workbook is explained in note 1083462. Please use following steps: 

  1. Open the BEx Analyzer 7x via Windows Start Menu.
    In the Gobal Settings dialog go to tab Statistic and activate the checkbox Collect Statistics:



  2. Close the BEx Analyzer and restart it.

  3. Now reproduce the performance issue. For SAP support please write down following details:
    3.1. Workbook ID from the analyzed workbook (see Find the Workbook ID)
    3.2.  Create a global variable variant of the used variable selection and write down the technical name of this variant. With this variant, we make sure to use the same variable selection.
    3.3.  Provide the exact navigation steps which were done while recording of the Statistics Workbook.
    3.4.  Add the '(Nav.) Step Counter' (1st column in Statistics Workbook) to the reproducing steps list.
    3.5.  Stop recording by removing the flag Collect Statistics in the Gobal Settings dialog on tab Statistic, and click ok to close the Global Settings.
    3.6.  Access Global Settings again, on tab Statistic press button Display Statistics to display the Statistics Workbook.

  4. Please add the Statistic Object Name to the rows with following steps:



  5. See following Example Statistics Workbook:

B - The heading columns of the Statistics Workbook

(Nav.) Step Counter

Event

Statistic Object Name

Validity Period

Number

Counter for Statistic Event calls

The step ID is counted up for each navigation step. For communication with SAP please write down what you have done in each step. If the workbook has more than one dataprovider then for processing each dataprovider one step is created.

This is the name of the event.

Here the technical name of the query, the key of the workbook or the ID of BEx Item are shown.

This is the runtime of event given in seconds.

For certin events you will find a value which indicates a size.

 

 

C - Frontend related events in detail

 

Online Documentation

In the Online Documentation you can find a general Overview of Statistics Events (table RSDDSTATEVENTS).

Event

Description

Bytes Transferred

The number indicates the transfered bytes for one step.

Load Workbook

This is the time for transfering the workbook from backend to temp. folder of client.

Generate Workbook

This event measures the time taken to generate the constructor of a workbook.

Not Assigned

This is a collective event for all parts that are not explicitly assigned to an event. The parts that are not assigned to an event are not belonging to the backend or frontend. This time is spend somewhere in between, durring the frontend backend communication. In most of the cases this is the network load (WAN). Especially if your Citrix Servers are located far from the application servers and the network load is high.

This is the time which belongs to data transfer in the landscape after leaving the BW server and before reaching the frontend tool, it includes complete time for network-traffic and occurs for every data transfer between BW Server and frontend. To improve the performance in the frontend/backend communication you should apply following notes:


1352375 - Performance improvements in a WAN (roundtrip reductions) > ANA_USE_SIDGRIDWBUF/ANA_USE_SIDGRIDMASS
1179647 - Performance: Network load in BEx Analyzer > ANA_USE_TABLE

 

 

Total DBSEL

How many cells reads the database.

Number of Excel Cell

This is the amount of data which is sent across the network.

Process Dialog

This event measures the time taken to process a Dialog (including the waiting time): selector dialog, open save dialog and variable screen.

Number of Blocks

Number of Blocks

Number of Symbols

Number of Symbols

Before Render

It is simply preparing the sheets for a clean rendering.

  • It sets the zoom to 100% on all visible sheets.
  • If the sheet is protected it is unprotecting it so it can do changes.
  • It makes sure that the deleted items are really deleted/cleaned.
  • And if there are styles that BEx Analyzer needs, it is ensuring that all are merged and present in the workbook.

Render Item

This is the Excel formatting time for rendering the BEx items. In column Statistic Object Name you can identify which BEx Item consumes the time.
You can reduce it by using the following analysis grid properties:
- Apply Formatting: deactivate
- Display Hierarchy Icons: "display +/-"
See Online Help: Analysis Grid

After Render

This is the time which is spent after rendering the design items. The time is mainly required by Excel for applying the formatting, drawing the graphs, formula calculation, exit macros (Workbook-Settings > TAB Exists > Run Macro On Refresh).

Wait Time, User

It is the time when the application was waiting for user action.


D - OLAP related events

These events are not are not relavnt for BEx Analyzer 7x. This runtime will be same in BEx Analyzer 3x, Tx RSRT or JAVA WEB. Please understand that the OLAP related events are not in focus of this wikipage, but you can find some short information about these events. Please also have a look at note 1681396

OLAP: Query Generation

This event measures the time that is needed to check the query definition and, if necessary, to generate the query

Authorization Check Selection

This event measures the time taken to carry out the OLAP authorization check.

Datamanager

Structure-/format-converting for frontend presentation. It can be optimized with help of compression & aggregates.

Total DBTRANS

Total Number of Transported Records

Total DBSEL

Total Number of Read Records

OLAP: Data Selection

This event measures e.g. the time taken to sort the read data (from DM) according to structure element selections or restricted key figures. The calculation of virtual key figures is done here as well.

OLAP: Datatransfer

In this part of the coding many OLAP features are processed, e.g. exception aggregations are carried out, formulas are calculated, and the correct number of decimal places for the data cells is determined. The time can be optimized by using cache. The number indicates the number of cells.

OLAP: Read Texts

Texts are read to sort the data. This event measures the time taken to call the text read class

 


Link to this page: http://wiki.sdn.sap.com/wiki/x/QANdDw
KBA Bridge 2518355 - Optimizing BEx Analyzer 7x Performance - Wikipage