query technical name

[Former Member]

Hi

I am generating a query on the statistics multicube/cube for displaying the top 25 queries which are taking long time. But i want the technical name of the query in rows. which infoobject should be used which could provide the technical name of the query .

plz guide

regards

[Former Member]

solved

[Former Member]

Hi,

have you tried 0TCTSTATOBJ infoobject?

Let me know which Cube you are using for this (is it 0TCT_C02)?

Hope it helps...

Regards,

Ashish

[Former Member]

Thanks for the reply

0TCT_C01

I found one infoobject but yet need to try.

Please let me know the infoobject technical name for query.

Regards

[Former Member]

The Characteristic for Query name is '0TCTBISBOBJ' (BI Application Object).

You also need to restrict characteristic - 0TCTBISOTYP with filter value as 'ELEM' (Query) so that the output only consists of Queries.

Regards

Swapnil