Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] FOCCACHE question
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] FOCCACHE question
 Login/Join
 
Gold member
posted
Hello

I never dealt with FOCCACHE and having issues with it. I have one HOLD file created from some code and will be using it in multiple reports on single HTML page. So, I am using FOCCACHE to hold it, so that data prep runs only once and all reports use the HOLD file instead of running the same data prep multiple times.
STATE foccache/HOLD_FILE.mas
-RUN
-IF &RETCODE EQ 0 THEN GOTO CONTINUE_REPORT ELSE GOTO CONTINUE_DATAPREP ;

I am using above code in reports to check FOCCACHE and direct flow to run report or data prep.
Even when I change my filter selections, its still running the same file from FOCCACHE. Am I missing something here?

Please suggest.

Thank you.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8202
All formats
 
Posts: 63 | Registered: September 13, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
The FOCCACHE files exist for a period of time (depending on your client setting) to give opportunities to reuse the same data without the need to reload.

When you are doing :
STATE foccache/HOLD_FILE.mas
-RUN
-IF &RETCODE EQ 0 THEN GOTO CONTINUE_REPORT ELSE GOTO CONTINUE_DATAPREP ;

The &RETCODE is always 0 until your system clear the FOCCACHE so you always branch to CONTINUE_REPORT

Depending on your situation, different options may apply

How does the HOLD file is generated ? On request by the user from selection screen ? From an overnight job ? A pre-processing ? ...

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


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2100 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Gold member
posted Hide Post
quote:
Originally posted by MartinY:
The FOCCACHE files exist for a period of time (depending on your client setting) to give opportunities to reuse the same data without the need to reload.

When you are doing :
STATE foccache/HOLD_FILE.mas
-RUN
-IF &RETCODE EQ 0 THEN GOTO CONTINUE_REPORT ELSE GOTO CONTINUE_DATAPREP ;

The &RETCODE is always 0 until your system clear the FOCCACHE so you always branch to CONTINUE_REPORT

Depending on your situation, different options may apply

How does the HOLD file is generated ? On request by the user from selection screen ? From an overnight job ? A pre-processing ? ...


HOLD file is generated by the user from filter selection screen. There is no over-night job.


WebFOCUS 8202
All formats
 
Posts: 63 | Registered: September 13, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] FOCCACHE question

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.