Skip to Content
Former Member
Nov 04, 2013 at 11:07 AM

KPI to calculate query usage


Hi Experts

I need to find the top ten reports based on maximum usage of query. I came to know that 0TCT_MC01_Q0200 query answers all this questions, In this report time stamp is filtered by 0I_24CTS (Last 24 hours)variable which takes last 24 hrs data only, So please guide me what are all the KPI need to consider to cal calculate the maximum usage, Tell me whether we can find the same in cube 0TCT_C01 and in table RSDDSTAT_OLAP.Even in tables I do know how to calculate.

Kindly Suggest