BI Stats

[Former Member]

Hi, i need help in interpreting the tables RSDDSTAT_OLAP and RSDDSTAT_DM. My requirement is to get the number of times a query is exectued by the user. Not sure how to use the fields in these tables to arrive at the needed info. Any help is greatly appreciated. Thanks.

[Former Member · Accepted solution]

Hi Stats,

Have you installed the BI Technical content in your system so that you can get the no of times the query is executed.

If technical content is installed in your system the you can make use of the multi providers 0TCT_M01/M02.

Check the Query Aggregated Query Runtime Statistics: Analysis --> 0TCT_MC01_Q0200    

http://help.sap.com/saphelp_nw70/helpdata/en/b8/609797e55a4c4998cc91fae068e7e2/frameset.htm

In table RSDDSTAT_OLAP make a selction on the infocube and the OLAP Statistic Object which is the query ID and execute. Then you should see how often the query was executed, by whom and which date/time.In field Query ID you type in the tech name of the query.

Regards

KP