BW Statistics 

Purpose

You use BW statistics to evaluate the fundamental functional areas of the Business Information Warehouse.

BW statistics provides you with the following options that allow you to evaluate data from both the OLAP processor and warehouse management. You can:

●      Get an overview of how InfoProviders, InfoObjects, InfoSources, source systems, queries, and aggregates are used

●      Analyze system performance and improve it

●      Improve the way in which aggregates are selected and used and reduce the effort of updating them

Implementation Considerations

BW statistics are delivered as part of technical content. The Technical Content role contains all the objects that you require to implement BW statistics, in particular the BW statistics MultiProvider (previously called the BW statistics MultiCube).

You install the technical content in the same way that you install Business Content; in the Business Content functional area of the Administrator Workbench.

Integration

The following diagram gives you an overview of the data flow for BW statistics:

The data in BW statistics is saved and managed in the Business Information Warehouse.

When a query is executed, data is specified for the OLAP server and for access to the database. This data is saved temporarily once the navigation step has been completed. This is also the case if you use the ODBO (OLE DB for OLAP) interface. Additional data is collected when the aggregates are filled and rolled up after data is loaded into warehouse management.

It does not take long to calculate and save BW statistics data. However, with larger installations the data set can be considerable. For this reason, you can activate and deactivate data entry individually for each InfoProvider in each area of OLAP and warehouse management. You can also delete saved data. (See Activating Data Transfers for BW Statistics)

The individual InfoCubes are filled by the various InfoSources. This reduces the time required to stage the data. Extractors are used to load the data.

The MultiProvider concept is used for reporting.

Features

The following are delivered with technical content for use in BW statistics:

BW statistics MultiProvider with InfoCubes

BW statistics queries with queries and diagrams

Example

The types of questions that BW statistics helps you to answer can be grouped as follows:

Information

●      Which InfoCubes, InfoObjects, InfoSources, source systems, queries, and aggregates are currently being used in the system? How often are these objects used? Which data sets are being used? Which users are currently working in the system?

●      Are there any queries that have been running for longer than the fixed time for online processing allows? Are tasks that run for a long time, such as loading data, carried out when the system is not working to capacity? (See Optimization.)

●      How does the data flow through the data warehouse? (Where does the data come from?) To which data targets is it moved?

Documentation

●      Which departments or users have used BW over a particular period of time (for example, during the last quarter, or in the last year)?

●      How has the workload for the database, for the OLAP processor, or for the front-end changed over time? What new demands are expected in the future?

Optimization

●      From time to time, a job that runs for a considerable amount of time has to be scheduled.

●        Printing reports in the background

●        Loading large volumes of data

●        Rolling-up the data in aggregates

When is the best time to schedule this kind of job? When is the system least busy? You can check the schedule later: Was this really the best time to schedule the job, or were there overlaps that cause the system to be overloaded?

●      Which aggregates could you use to reduce the runtime of the queries? At what rate does the time taken to load the data, including the time it takes to roll-up the aggregates, increase?

●      Which aggregates, InfoCubes, InfoObjects, or InfoSources are no longer used and can therefore be deleted? Can you or must you change the periodic loading of InfoCubes?

●      Performance: To what extent do queries put pressure on the database, the OLAP server, and the front end? Can this pressure be reduced by changing the definition of the queries?

●      How much or how little is the InfoCube used, and how complicated is it to load data into the InfoCube?