SDN上摘抄的印度人写的RSDDSTAT*等表的用途

BI 7.x:

- to activatestatistics goto tcode RSA1 .. Tools ... Settings for BI Stats 

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

- set statsfor Web Template- set stats for Workbook 

RSA1 -工具-业务智能统计的设置,对query, infoprovider,等全选。

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

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

- RSDDSTATAGGR

-- DetailTable for Aggregate Setup 集合

- RSDDSTATAGGRDEF HANDLE: 查询运行时间对象 query runtimeobject

-- DetailTable of Navigation for each InfoCube/Query

- RSDDSTAT_OLAP: 统计的联机分析处理＋前端部分

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

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

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

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

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

- RSDDSTATSTEPTP:

-- type ofsteps

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

- RSDDSTATHANDLTP:

-- combines Handle &Step type

-- helps to identify wherethe time is being spent 

- RSDDSTAT_DM:

-- Statistics DataManager forQuery execution

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

-- gives the detail of theDB access

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

-- look STEPID up inRSDDSTAT_DM- gives the InfoProvider its reading

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

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

- RSDDSTATWHM:

-- Warehouse management statistics

-- time ittakes to do a load 

-RSDDSTATCOND

-- InfoCubeCompression

-RSDDSTATDELE

-- InfoCubeDeletions

-RSDDSTAT_WRITE

-- InfoCubeWrites

-RSDDSTATBCACT

-- BusinessContent Activation Statistics

- RSDDSTATCOND 

-- Dataon Condensing Run InfoCube

-RSDDSTATEXTRACT

-- Time oflast delta load