BW Statistics

Description:


BW statistics is nothing but the SAP deliverd 1multiprovider and 5 cubes which can get the statistics of the objects developed. We have to enable and activate the BW statistics for particular objects which you want to see the statistics and to gather required data. But this no way will improve the performance. But we can analyze the statistics data and based on the data can decide on the ways to improve performance i.e. setting the read mode, compression, partitioning, creation of aggregates etc.....



BW Statistics is a tool

-for the analysis and optimization of Business Information Warehouse processes.

-to get an overview of the BW load and analysis processe



The following objects can be analyzed here:

Roles

SAPBWusers

Aggregates

Queries

InfoCubes

InfoSources

ODS

DataSources

InfoObjects

The BW Statistics sub-area is the most important of the two

1. BW Statistics

2. BW Data Slice

BW Statistics data is stored in the Business Information Warehouse.



This information is provided by a MultiProvider (0BWTC_C10), which is based on several BW BasisCubes.



OLAP (0BWTC_C02)

OLAP Detail Navigation (0BWTC_C03)

Aggregates (0BWTC_C04)

WHM (0BWTC_C05)

Metadata ( 0BWTC_C08 )

Condensing InfoCubes (0BWTC_C09)

Deleting Data from an InfoCube (0BWTC_C11)

BW Data Slice to get an overview of the requested characteristic combinations for particular InfoCubes and of the number of records that were loaded. This information is based on the following BasisCubes:

-BW Data Slice

-Requests in the InfoCube

BW Data Slice

BW Data Slice contains information about which characteristic combinations of an InfoCube are to be loaded and with which request, that is, with which data request.



Requests in the InfoCube

The InfoCube Requests in the InfoCube does not contain any characteristic combinations you can create queries for this InfoCube that return the number of data records for the corresponding InfoCube and for the individual requests data flow fall into below data.

- data load data management

- data analysis