Focal Point
[Resolved]Operational Report..

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/52410792

March 04, 2009, 03:41 PM
malapejohn
[Resolved]Operational Report..
I want to display the running time in my operational report in my footer.

Which parameters do I need to set within the
-INCLUDE RUNNINGTIME01 fex?
&&RT_INIT ??
Im weary of changing a global variable.

What this be the sequence of events?
-SET &&RT_INIT='Y'
-INCLUDE RUNNINGTIME01
RUN MY FOCEXEC.
AT THE END OF MY FOCEXEC I CALL THE PROCEDURE AGAIN
-SET &&RT_INIT='N'
-INCLUDE RUNNINGTIME01

Any opinions on the best way to incorporate within a Operational Report??

This message has been edited. Last edited by: malapejohn,


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
March 04, 2009, 06:08 PM
EricH
You should not have to do anything at all. runningtime01.fex is self starting and should not require you to set any variables ahead of time.

There have been some isolated cases in earlier releases of PMF where setting IBIF_persistentamp to Yes in the WebFOCUS Administration Console caused issues. These problems were eliminated starting with PMF 5.1. If you are running an earlier release of PMF and are having issues with global && variables, go to the WebFOCUS Administration Console, Configuration, General, and set IBIF_persistentamp to No


Incidentally, I would recommend that instead of doing a

-INCLUDE RUNNINGTIME01

at the beginning of the report, you do a

-INCLUDE FOCEXEC_INFO

This gives you some additional debugging information.

EricH
March 05, 2009, 11:24 AM
malapejohn
-INCLUDE RUNNINGTIME01
-DEFAULTH &BEGIN_TSTP = '2007/01/01 00:00:01.500000' ;
-DEFAULTH &END_TSTP = '2007/01/01 00:00:03.500000' ;
-SET &BEGIN_TSTP_TT = HINPUT(26, 2009/03/05 11:21:16.366000, 10, 'HYYMDm') ;
-SET &END_TSTP_TT = HINPUT(26, 2009/03/05 11:21:16.413000, 10, 'HYYMDm') ;


In Decoding my Operational Report I find this section. This is the section to determine the Run Time??


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
March 05, 2009, 11:30 AM
malapejohn
I was able to get the information I needed from this variable &DIFF_PR

Thanx


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server