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     [SOLVED] How to have one query that all other tiles in a Portal use
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] How to have one query that all other tiles in a Portal use
 Login/Join
 
Platinum Member
posted
Hi,

I'm trying to make my queries more efficient in a portal by having one giant data pull that my other queries then utilize.

I am assuming there are ways to do this via foccache but I'm curious if there is another option. Is this something I should open a ticket about? Open to hearing what other people do here.

Thanks a lot as always!!

This message has been edited. Last edited by: Brandon Andrathy,


WebFOCUS 8204
 
Posts: 119 | Registered: July 10, 2018Reply With QuoteReport This Post
Guru
posted Hide Post
In the Client admin console you can set a procedure to be run on login. With this procedure you can store data in foccache


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 435 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Thank you Frans,

I spoke with IBI (thanks Walter!) and looks like there is another option we can use by setting up an APP path and exporting our data via report caster on a daily basis.

Closing this out


WebFOCUS 8204
 
Posts: 119 | Registered: July 10, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] How to have one query that all other tiles in a Portal use

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