BW Statistics MultiProvider
Queries
Purpose
You can use the BW statistics MultiProvider to generate reports using several BasicCubes.
Since data can be evaluated both from the OLAP processor area as well as the Warehouse Management area, the BW statistics queries for the BW statistics MultiProvider offer comprehensive options within the framework of technical content:
Diagram: OLAP Records per InfoCube (0BWTC_C10_Q51)
Diagram: OLAP Times per InfoCube (0BWTC_C10_Q50)
Filling Variables: Navigation Steps for a Time Period (0BWTC_C10_Q001)
Rolling up Aggregates (0BWTC_C10_Q211)
Compressing Data in InfoCubes (0BWTC_C10_Q250)
Runtime Query (0BWTC_C10_Q014)
Deleting Data in InfoCubes (0BWTC_C10_Q251)
Deleting Data in InfoCubes - Detail, Times (0BWTC_C10_Q253)
Deleting Data in InfoCubes - Detail, Records (0BWTC_C10_Q254)
Deleting Data in InfoCubes - Overview (0BWTC_C10_Q252)
Average Time per Query (0BWTC_C10_Q021)
Average Time per Query (0BWTC_C10_Q507)
OLAP Use (0BWTC_C10_Q010)
OLAP Usage per User (0BWTC_C10_Q011)
OLAP Use per User (Total Number of Records) (0BWTC_C10_Q506)
OLAP Use per User (Total Time) (0BWTC_C10_Q505)
OLAP Use per User (Time) (0BWTC_C10_Q503)
OLAP Use per InfoCube (0BWTC_C10_Q013).
OLAP Use per InfoCube (Records) (0BWTC_C10_Q501)
OLAP Use per InfoCube (Time) (0BWTC_C10_Q500)
OLAP Use per Query (0BWTC_C10_Q012).
OLAP Use per Query (Time) (0BWTC_C10_Q502)
OLAP Use by Date (0BWTC_C10_Q015)
OLAP Use by Time (0BWTC_C10_Q016)
WHM Use per InfoCube (0BWTC_C10_Q315).
WHM Use per InfoSource (0BWTC_C10_Q314).
WHM Use per Day (0BWTC_C10_Q311).
WHM Use per Time of Day (0BWTC_C10_Q312).
OLAP Performance with/without Reading / Aggregates (0BWTC_C10_Q022)
Transfer Methods: Loading Data (0BWTC_C10_Q313)
Using InfoCubes: OLAP / WHM (0BWTC_C10_Q400)
Using InfoCubes: OLAP / WHM - Records (0BWTC_C10_Q402)
Using InfoCubes: OLAP / WHM - Times (0BWTC_C10_Q401)
Using InfoCubes: Reporting / Loading (0BWTC_C10_Q508)
Using Hierarchies(0BWTC_C10_Q018)
Using InfoCubes (0BWTC_C10_Q020)
The following graphic gives an overview of the queries for BW statistics MultiProviders, assigned according to their “main characteristic”. (Several characteristics are possible.)
