Question Re: BI Stats in Technology Q&A

BI Stats

Former Member — Tue, 18 Sep 2012 09:49:12 GMT

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.

Re: BI Stats

former_member182470 — Tue, 18 Sep 2012 10:08:22 GMT

Hi,

There is one standard Query called No. of executions per BI Application. There are many standard Query Runtime Stats reports available.

Have you installed BI Admin Cockpit......?

Regards,

Suman

Re: BI Stats

Former Member — Tue, 18 Sep 2012 13:08:44 GMT

just use 0tct_c01 cube that will give you historical data on number of times query is executed. make sure you have the statistics turned on from rsa1 tool bar TOOLS setting for BI statistics and turn them to x the ones that u need statistics on, step1 will give you query variable screen execution and step 2 will give you query run..

Re: BI Stats

Former Member — Tue, 18 Sep 2012 13:43:45 GMT

Hi,

Install the Stats first. Then build a query over 0TCT_M01 multiprovider with BI application object in rows(query name) and in the columns create a formula which gives the total unique number of front end session for each query using exception aggregation. This will give u the count of number of times a user logged into Bex and executed the query. If the user executes the same query twice in the same session it will give the count as one as the session is same.

Regards,

Raghavendra.

Re: BI Stats

Former Member — Thu, 20 Sep 2012 06:16:41 GMT

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