I pull data from an sql stored proc. After my intial run that has date parameters, there is the first report view - Division. On this first view, I have the ability to drill down to group..ect. which are all separate fex. Is it possible to somehow store this first initial pull and have the drill downs (fex's) read off this instead of re-query the sql server? Thanks for any info possible!This message has been edited. Last edited by: Kerry,
WebFocus 7.7.02 WinXP
December 06, 2010, 03:22 PM
Francis Mariani
FOCCACHE was introduced for this purpose, but it's available for 7.6.5 and above.
Perhaps you could make sure that the web browser cache is used when the user is navigating the report.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
December 06, 2010, 03:46 PM
JOE
Is this creating a temp file specific to each user?
WebFocus 7.7.02 WinXP
December 06, 2010, 04:04 PM
Waz
The temp file is related to the users session.
Typically the files only exist of a day.
Check it out in the documentation.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
December 10, 2010, 05:17 PM
Dannyg
Could you use a PDF drill through with a hold file? All of the reports are in one coupound report from one fex.
.
December 10, 2010, 05:18 PM
Dannyg
quote:
Originally posted by Dannyg: Could you use a PDF drill through with a hold file? All of the reports are in one compound report from one fex.