Skip to Content
Former Member
Nov 21, 2007 at 04:58 PM

0TCT_C01 - Handle ID, OLAP Stat


I'm trying to track the number of times a query is being executed on each infoprovider as part of a cleanup project. I've activated the BI Statistics and I am loading them daily. In order to tract the query usage, I've created a query on the 0TCT_C01 cube.

My report displays the User ID; InfoProvider Type (set to CUBE, ODSO, and MPRO); BI Application Obj (Query name); Step Type, OLAP Stat (BEx 3.5 and BI 7.0); and the Count for BI ApplObjc (Key Figure). The query is filtered to BI Application Type = BTMP and XLWB, and BI Application Object Type = ELEM. I added these filter per following the SAP paper:

I've noticed that for certain rows of data, the Count field has a value greater than 1. When I drilled down to the "Handle ID, OLAP Stat" (0TCTHANDLID) level, I see that there are multiple entries there.

Does anyone know what this field tracks? That field only has a key, no text. Should I just restrict that field to a certain value range in order to show a counter for when the query is run?