Explain About BW Statistics

Explain about "BW statistics" and how it is useful in improving the performance in detail?

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

Get help for your SAP BW problems
SAP BW Forum - Do you have a SAP BW Question?

SAP Business Warehouse Books
SAP BW Books - Certification, Interview Questions and Configuration

SAP BW Tips
SAP BW Tips and Business Information Warehouse

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.