Report execution time in Query objects

[Former Member]

Hi Experts,

Is there a way we can fetch the report execution time in a variable and then again use it another query on same document.

Have a requirement to fail a schedule report if the query execution is more then 5 Mins and then re run the report after some time.

Sometimes the load on the DB Server is high and query takes time.

I can make it fail if somehow I am able to get the report execution time in another query or some other suggestions

BO XI 4.1 SP6

[Former Member]

Hi,

Please create a variable with =LastExecutionDuration() this would give you the time taken in seconds.

Regards

Niraj

[Former Member]

Niraj ,

Yes that will give me however I require that object to be taken on another query.

that is what I am looking for

[Former Member]

Does Open Document helps you?

Regards

Niraj

[Former Member]

No It will not help , looking for a variable that can be created at universe\ webi level which gives me the Last execution time and then I can take the variable at query level in same  document Other query and then

I am going to fail the whole report if the Query execution time is > 5 Mins