Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] how to run multiple queries at same time in one fex

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] how to run multiple queries at same time in one fex
 Login/Join
 
Platinum Member
posted
Hello,

I am wondering if there is a command in web focus where you can run multiple table file queries against a data warehouse at the same time.

So for example, I want to run the below two queries at the same time in a single .fex instead of one at a time.

TABLE FILE CAR
SUM
RETAIL_COST
BY COUNTRY
END

TABLE FILE CAR
SUM
DEALER_COST
BY COUNTRY
END

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


WebFOCUS 8204
 
Posts: 152 | Registered: July 10, 2018Report This Post
Virtuoso
posted Hide Post
Brandon

There is no way to do that as when the query is submitted it uses an available agent on the reporting server and there is no pre-processing to tell it to use more than one agent.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Virtuoso
posted Hide Post
Brandon,
What do you mean by "at the same time"?
What do you want to achieve?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Platinum Member
posted Hide Post
Hey All,

So my goal is to have queries in a .fex run at the same time instead of sequentially so that they don't take as much time.

I could run them in separate .fexes in the BIP however, I have some javascript at the bottom of the fex that refreshes all of my other tiles once this .fex runs.

Pseudo code below:

 

TABLE FILE CAR
SUM
RETAIL_COST
BY COUNTRY
ON TABLE HOLD AS 'FOCCACHE/HOLD1'
END

TABLE FILE CAR
SUM
DEALER_COST
BY COUNTRY
ON TABLE HOLD AS 'FOCCACHE/HOLD2'
END

function myFunction()
{
var frameArray = [ "Panel_1_1", "Panel_2_1"];
parent.BipIframeInterface.refresh(parent.BipIframeInterface.REFRESH_ALL_BUT_ARRAY, name, frameArray);
}

 


If I do put both of my table files in separate fexes, I'd like to be able to refresh my tiles only when both .fexes have run.

Hoping there's an easier way to request both table files to be run on SQL Server at the same time.

I have something complicated in mind as a worst case where I refresh an individual tile, pass a parameter back to the master .fex and go to different parts of the code that then goes down to the javascript to refresh the tiles. Hoping I don't have to do that.


WebFOCUS 8204
 
Posts: 152 | Registered: July 10, 2018Report This Post
Platinum Member
posted Hide Post
this thread looks exactly like what I need.

http://forums.informationbuild...587038595#3587038595

Jack Gross said this: "Have the "parent" fex return an initial html page, which on load submits N forms, one for each of the "child" fexes, to run them in parallel"

Does anyone have an idea what the code would look like for this? Has something else been developed 9 years later in this regard?


WebFOCUS 8204
 
Posts: 152 | Registered: July 10, 2018Report This Post
Guru
posted Hide Post
So are you doing all of this for performance issues of 2 Reports? In that case I would try other options, like persisting data or generating data at logon when the query itself can't be improved.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 454 | Location: Europe | Registered: February 05, 2007Report This Post
Platinum Member
posted Hide Post
Hey Frans, thanks for the reply.

I have tried the persisting data via App Path. Unfortunately that won't work as it's too much maintenance on the developer side.

AS far as generating data at logon, are you saying run all the queries only once when the user first gets on and then refreshing all the tiles with javascript? Or are you referring to the foccache server setting?


WebFOCUS 8204
 
Posts: 152 | Registered: July 10, 2018Report This Post
Platinum Member
posted Hide Post
ok i figured all this out. I created an HTML wrapper with 4 report iframes that ran the agents separately. then passed the parameters to FOCCACHE and now all my other reports are feeding from that. I think I'm good to go.

Thanks all for the help


WebFOCUS 8204
 
Posts: 152 | Registered: July 10, 2018Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] how to run multiple queries at same time in one fex

Copyright © 1996-2020 Information Builders