Report Execution

[Former Member]

Hi Experts,

I have some 100 odd queries. Among these lot of queries are taking a lot of time to execute.

Is there any way to find out which are taking long time to execute.

Thanks in Advance,

Anil.

[Former Member · Accepted solution]

Hi Anil,

Do you have 0TCT_C01 infocube installed in your Bw system , then u can check query 0TCT_C01* BW statistics runtime aggregated. This report gives list fo all queries with their statistics.

Thanks

Deepak chavan

[Former Member · Accepted solution]

Hi Deepak,

Thanks for ur reply. It was helpful.

Could you please explain in detail.

Thanks,

Anil.

[Former Member · Accepted solution]

Hi Anil,

Can you please install 0TCT_C01 infocube and its queries from business content.

then once you execute report list of queries which are taking time can be get.

Thanks

Deepak.

[Former Member · Accepted solution]

Hi Deepak,

I already installed 0TCT_C01 cube, I am confused in selecting the required queries.

If you don't mind, Please name some/

Thanks,

Anil.

[Former Member · Accepted solution]

Hi Anil,

Can you please check TCT_C01_QRY_RUNTIME_AGGREGATE query.

Thanks & Regards

Deepak Chavan.

[Former Member · Accepted solution]

Hi Deepak,

Thanks for the information, I really appreciate ur response.

However, I am not able to find that query, But i found 0TCT_MC01_Q0200  query which is giving me the statistics for the last 24 hrs.

Regards,

Anil.