What does 0TCTSTEPCNT have to do with 0TCTQUCOUNT?

[Former Member]

I am writing a query to get the number of times a query has been run.

I was using 0TCTQUCOUNT to determine this.

I then had a look at the numbers and they seemed very high for some queries.

I investigated the cube (0TCT_C01) and discovered that 0TCTQUCOUNT was appearing mutliple times for a single front end session. This appeared to be because 0TCTSTEPCNT will trigger this value many times for a single session.

My question is, to get an accurate count of how many times a query has run, what do I have to filter on 0TCTSTEPCNT?

Also, since there are no descriptions for the master data associated with 0TCTSTEPCNT, does anyone have an idea on what the various step values represent?

Thank you for your help in advance.

[paulo_gorenstein]

Just filter 0TCTSTEPCNT = 1 for "ELEM' types.

[Former Member]

Hi,

Is your problem solved? We too are confused with the same!

Thanks & Regards,

Vidya

[Former Member]

I ended up doing some exception aggregation on UTC time stamp where the step counter = 1.

That seemed to do the trick.

I'm not 100% sure that is the right way but it is the best way I found.

If anyone has any other ideas or approaches, feel free to post.

[Former Member]

Hi,

Have you thought about filter on both session id and query counter? or it's also possible for you to go to transaction st03n BW profile to get the times for query execution in a specified time range.

Best regards,

Matt.

[sap_cohort]

It really shouldn't be this hard to get a simple query like this. Doesn't SAP provide this Basis kind of information?

[Former Member]

I have used custom queries for these requirements and the only restrictions I've used are on objects '0TCTBISOTYP' (restrict to 'ELEM' ~ Query and '0TCTOBJVERS' (restrict to 'A' ~ Active).

Hope this helps.

[Former Member]

Hello,

I have the problem. Does anyoune solved it yet?