Child pages
  • BW Statistics and RSDDSTAT* views, tables
Skip to end of metadata
Go to start of metadata

BW 3.x:

- before you use table RSDDSTAT you must activate the BW Statistics: RSA1 -> Tools -> BW Stats for InfoProviders

- can collect stats for OLAP (frontend) & for Loading (WHM backend)

- make sure that you have stats checked for ALL InfoProviders that you are querying on

- all RSDDSTAT tbls get updated when BW stats are switched on

- all RSDDSTAT tbls feed into the ST03 monitor 

==================================================
BI 7.x:

- to activate statistics goto tcode RSA1 .. Tools ... Settings for BI Stats 

-- set stats for Query- set stats for InfoProvider (as per 3.x)

- set stats for Web Template- set stats for Workbook 

==================================================

RSDDSTAT* predefined views & tables in BI 7.x:

- RSDDSTATAGGR

-- Detail Table for Aggregate Setup

- RSDDSTATAGGRDEF

-- Detail Table of Navigation for each InfoCube/Query

- RSDDSTAT_OLAP:

-- view containing data from the events from the areas for the front end and calculation layer of the analytic engine (Front End/OLAP)

-- similar to old 3.x one but now has different breakdown for OLAP time

-- SESSIONID: when you start your session (i.e. run the query)

-- STEPUID: when you do something different (i.e. navigate)#

-- Events ID 9000-9011: more info for QTIMEDB
-- Events ID 3000-3999: more info for QOLAPTIME

- RSDDSTATSTEPTP:

-- type of steps

-- BEX, BEX3, BRCS (broadcasting), EXTN (external read), JAVA, MDX

- RSDDSTATHANDLTP:

-- combines Handle & Step type

-- helps to identify where the time is being spent 

- RSDDSTAT_DM:

-- Statistics DataManager for Query execution

-- view containing data from the events from the area for the aggregation layer and analytic engine (Data Manager).

-- gives the detail of the DB access

-- get the STEPID of the RSDDSTAT_OLAP entry with Event ID = 9000 (DBTIME)

-- look STEPID up in RSDDSTAT_DM- gives the InfoProvider its reading

-- gives the aggregate being used- if $__ in AGGREGATE => BIA is being used

-- TABLTP: which fact table is being used- TIMEREAD: time spent reading- WP_ID: which work process is being used 

- RSDDSTATWHM:

-- Warehouse management statistics

-- time it takes to do a load 

- RSDDSTATCOND

-- InfoCube Compression

- RSDDSTATDELE

-- InfoCube Deletions

- RSDDSTAT_WRITE

-- InfoCube Writes

- RSDDSTATBCACT

-- Business Content Activation Statistics

- RSDDSTATCOND 

-- Data on Condensing Run InfoCube

- RSDDSTATEXTRACT

-- Time of last delta load