OLAP Use by Date (SAP Library - BW Statistics MultiProvider Queries)

OLAP Use by Date

Technical name: 0BWTC_C10_Q015

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

The OLAP Use by Date (0BWTC_C10_Q015) query gives you an overview of the utilization of the Business Information Warehous from a historical perspective. You can move keys from the historical analysis for your further planning.

The graphic display gives you a quick overview of the total times when executing all queries, as well as the total number of records that are thereby read and are subdivided according to calendar days.

absolute values

Example

Absolute values can stand out:

a regular, very low amount of data, meaning a very low utilization, for example, on Sundays and holidays
regular peak values, meaning high utilization, for example, at the end of the month or on each Monday. If the high utilization causes performance problems, you need to execute a performance analysis for the days with the peak values.

the relationship between times and number of records within the time period concerned

Example

If the times have clearly increased in comparison to the number of records, this could, for example, indicate that the database statistics (not to be confused with BW statistics) are outdated for some InfoCubes (more precisely, for the tables of some InfoCubes).

In order to determine which InfoCube(s) is/are affected, you can look at a BW statistics query, which includes the InfoCube characteristic or even the query characteristic in the rows, such as OLAP Use per InfoCube (0BWTC_C10_Q013) or Runtime Query (0BWTC_C10_Q014). Afterwards, update the database statistics in the Administrator Workbench.