Time taken by the Report to Refresh

[sheshagiri]

Hi,
How to get the exact time taken by the report to refresh in minutes and seconds. I want to include the time in a cell.

Thanks in Advance.

Giri

 

[Sridharan]

Hi,

I don't think it is available there by default even when using SDK. One can get the LastRefreshTime and maybe if we can get the StartTIme we should be able to compute the refresh time.

Sri

 

[blom0344]

I have read other forum discussions about this and one of the options is to create a dataprovider before the existing one and a second one after it. If you retrieve a timestamp from both queries , you should be able to subtract these timestamp at report level , which will give you roughly the time it takes for the total refresh time of the actual dataprovider.......

T. Blom
Information analyst
tbl@shimano-eu.com

 

[Sridharan]

Hi Blom,

This thread is getting bit interesting.

I like the word ROUGHLY in your message Blom but still when you say create 2 New DP's one before existing one and one after it. Can you tell the exact sequence of what you mean by before one and after.

Thanks
Sri

 

[blom0344]

There are numerous ways to get the job done, but remember BO will run multiple dataprovider sequentially. So , for instance run this as first dataprovider:

SELECT TO_NUMBER(SUBSTR(TO_CHAR(SYSDATE,'HH:MM:SS'),1,2))*3600+
TO_NUMBER(SUBSTR(TO_CHAR(SYSDATE,'HH:MM:SS'),4,2))*60+
TO_NUMBER(SUBSTR(TO_CHAR(SYSDATE,'HH:MM:SS'),7,2)) AS START FROM DUAL

(this is an example using ORACLE)

This query takes about 10 milliseconds to complete. The real dataprovider is created as second one, it takes 2 minutes to run.

The third dataprovider is:

SELECT TO_NUMBER(SUBSTR(TO_CHAR(SYSDATE,'HH:MM:SS'),1,2))*3600+
TO_NUMBER(SUBSTR(TO_CHAR(SYSDATE,'HH:MM:SS'),4,2))*60+
TO_NUMBER(SUBSTR(TO_CHAR(SYSDATE,'HH:MM:SS'),7,2)) AS END FROM DUAL

Now subtract START from END . This is very close to the time it takes for DP2 to run (because the DUAL queries as so fast...........)

A bit of calculating at report-level can give you nice notation again in minutes:seconds format....

T. Blom
Information analyst
tbl@shimano-eu.com

 

[Sridharan]

Hi Blom,

Thanks for the reply. I was also thinking on the same line except that instead of taking from DUAL for the Dummy Dp's I was thinking more of the LastRefreshTime. Anyway both use the same sequencing logic.

Thanks Again
Sri

 

[blom0344]

Well, I may be overlooking something, but last refresh time is specific for a given DP. You need a second timestamp in order to get a difference to calculate how long refreshed lasted....

T. Blom
Information analyst
tbl@shimano-eu.com

 

[Sridharan]

Well even I may be. Tell me if this makes some sense. Have two DP's.

1. Dummy DP
2. Main DP

Take the 2nd DP's LastRefreshTime and 1st DP's LastRefreshTime and use it for Calculation.

Sri