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