on 09-13-2014 11:13 AM
Dear SCN Members,
Please help me out in this.
What are the tables where query view usage statistics will be stored in sap bw?????
Regards,
Mano
Hi,
please check the below statistics cube- 0TCT_C01
if don't have install the form the BI content then load it to data check the cube data.
it will says which query how many users are using.
Thanks,
Phani.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Go to ST13 tcode and provide tool name BW_QUERY_USAGE their it will provide all details .
Table : RSDDSTAT_OLAP
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have a look into BW's statistics tables:
RSDDSTAT_OLAP - Front-end & OLAP Statistics -> this is table for BEx query usage data
RSDDSTAT_DM Data - Manager Statistics
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can check table - RSDDSTAT_OLAP, if you so not have 0TCT_C01 installed.
HANDLETP = OLAP .
Hope it hels.
Regards,
Sudhir
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello SCN,
Can you plz help me out on this.
Regards,
Manohar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear All,
What ever you have replied is related to queries but not query views, what I observed in your responses.
Kindly help me out in this .
Regards,
Manohar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Mohanar, in the table RSDDSTAT_OLAP there are a all BEx objects tracked. See field Event ID in the same table which describes object involved. Have a look into this help page for details:
https://help.sap.com/saphelp_nw70ehp1/helpdata/en/45/f0488a1aa03115e10000000a1553f7/content.htm
Cheers
m./
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.