BW Statistics Queries (SAP Library

BW Statistics Queries

Use

The BW statistics queries are delivered with the technical Content. They contain pre-defined queries and diagrams. BI users can use the BW statistics queries to graphically evaluate and monitor Business Information services relevant to run-time.

Note

Time is always specified in seconds in BW statistics.

Structure

The BW statistics queries are mostly assigned to the BW Statistics MultiProvider. Exceptions are a few queries, which are assigned to the InfoCube BW Statistics - OLAP, Detail Navigation. In addition, there are queries for the InfoCube BW Metadata.

Assigned according to the InfoCubes, the following queries belong to BW statistics:

BW Statistics MultiProvider (0BWTC_C10)

Technical Name	Description
0BWTC_C10_Q051	Diagram: OLAP Records per InfoCube
0BWTC_C10_Q050	Diagram: OLAP Times per InfoCube
0BWTC_C10_Q001	Fill Variable: Navigation Steps for Time Period
0BWTC_C10_Q211	Rolling up Aggregates
0BWTC_C10_Q250	Compressing Data into InfoCubes
0BWTC_C10_Q014	Query Runtime
0BWTC_C10_Q251	Deleting Data in InfoCubes
0BWTC_C10_Q253	Deleting Data in InfoCubes - Detail, Times
0BWTC_C10_Q254	Deleting Data in InfoCubes - Details, Records
0BWTC_C10_Q252	Deleting Data in InfoCubes - Overview
0BWTC_C10_Q507	Average Time per Query
0BWTC_C10_Q021	Average Time per Query
0BWTC_C10_Q010	OLAP Use
0BWTC_C10_Q011	OLAP Use per User
0BWTC_C10_Q506	OLAP Use per User (Total Number of Records)
0BWTC_C10_Q505	OLAP Use per User (Total Time)
0BWTC_C10_Q503	OLAP Use per User (Time)
0BWTC_C10_Q013	OLAP Use per InfoCube
0BWTC_C10_Q501	OLAP Use per InfoCube (Records)
0BWTC_C10_Q500	OLAP Use per InfoCube (Time)
0BWTC_C10_Q012	OLAP Use per Query
0BWTC_C10_Q502	OLAP Use per Query (Time)
0BWTC_C10_Q015	OLAP Use by Date
0BWTC_C10_Q016	OLAP Use by Time
0BWTC_C10_Q315	WHM Use per InfoCube
0BWTC_C10_Q314	WHM Use per InfoSource
0BWTC_C10_Q311	WHM Use per Day
0BWTC_C10_Q312	WHM Use per Time of Day
0BWTC_C10_Q022	OLAP Performance with/without Being Read/Aggregates
0BWTC_C10_Q313	Transfer Method Loading Data
0BWTC_C10_Q400	InfoCube Use OLAP / WHM
0BWTC_C10_Q402	InfoCube Use OLAP / WHM - Records
0BWTC_C10_Q401	InfoCube Use OLAP / WHM - Times
0BWTC_C10_Q508	InfoCubes Use Reporting / Loading
0BWTC_C10_Q018	Hierarchy Use
0BWTC_C10_Q020	InfoCube Use

BW Statistics - OLAP, Detail Navigation (0BWTC_C03)

Technical Name	Description
0BWTC_C03_Q018	Hierarchy Use
0BWTC_C03_Q210	Use of InfoCube / Aggregates When Navigating
0BWTC_C03_Q017	InfoObject Use
0BWTC_C03_Q023	InfoObject Use When Navigating

BW Statistics Metadata (0BWTC_C08)

Technical Name	Description
0BWTC_C08_Q110	BW user
0BWTC_C08_Q105	Business Content workbooks
0BWTC_C08_Q103	Business Content DataSources
0BWTC_C08_Q101	Business Content InfoCubes
0BWTC_C08_Q100	Business Content InfoObjects
0BWTC_C08_Q107	Business Content InfoSet queries
0BWTC_C08_Q106	Business Content InfoSets
0BWTC_C08_Q102	Business Content InfoSources
0BWTC_C08_Q104	Business Content ODS
0BWTC_C08_Q108	Business Content Queries
0BWTC_C08_Q109	Business Content Roles

The following graphic gives an overview of the BW statistics queries, assigned according to their “main characteristic”.

The symbols next to the queries represent the following:

This graphic is explained in the accompanying text Large Number of Key Figures

This graphic is explained in the accompanying text Very Large Number of Key Figures

This graphic is explained in the accompanying text Large Number of Free Characteristics

This graphic is explained in the accompanying text Suitable for Diagram

This graphic is explained in the accompanying text