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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     (SOLVED) BI Portal (8.009) data source question

Read-Only Read-Only Topic
Go
Search
Notify
Tools
(SOLVED) BI Portal (8.009) data source question
 Login/Join
 
Guru
posted
I'm looking for a way to create a HOLD file that reports, located within the individual panels can access. It appears to me that each panel is creating a separate session to the DBMS (MSSQL). Is this a possibility?

This message has been edited. Last edited by: Don Garland,


WebFOCUS Administrator @ Worldpay FIS
PROD/DEV/TEST: 8204, SANDBOX: 8206 soon - BIP, Reportcaster, Resource Manager, EUM, HyperStage soon, DB: HIVE,Oracle,MSSQL
 
Posts: 291 | Location: Greater Cincinnati  | Registered: May 11, 2005Report This Post
Guru
posted Hide Post
Adding a bit more context as I continue to experiment with this idea.

I've been playing with SAME_DB as a solution to creating a HOLD file in one FEX and using it in another. Running the 1ST FEX, I can see the temdb table being created on the SQL Server, and according the FM, the HOLD file should persist as long as the original FEX session is active or another is referencing it. " .... table is dropped automatically when the session that created the table ends and all other tasks have stopped referencing it. The .....

Here is an example to support my questions below;

1ST FEX
-* This FEX creates the HOLD file and runs a report to return the TOP 1 Data
EXAMPLE - Initial FEX to create the HOLD on the DBMS
TABLE FILE DBNAME
PRINT FIELD1
      FIELD2
BY    SORTFIELD
ON TABLE HOLD FORMAT SAME_DB PERSISTENCE GLOBAL_TEMPORARY
END
-RUN


TABLE FILE ????
PRINT *
BY HIGEST 1 SORTFIELD
END
-RUN
-EXIT



2ND FEX
-* This FEX uses the HOLD file and runs a report 
TABLE FILE ????
PRINT *
BY LOWEST 1 SORTFIELD
END
-RUN
-EXIT



Here is what I think I know for sure, based on the manual;
1. The manual indicates that there is a window open by the 1ST FEX, and as long as that FEX (or any other FEX accessing that file) is in session with the DBMS, the HOLD file is available.

Here is what is not clear to me;
1. What is the proper way to access the HOLD (????) FILE file;
A.Within the 1ST fex (which no doubt is in session) and B. the 2ND FEX, which normally is a new session. But should keep the file open if it can get it's hands on it.

Any thoughts or questions on this scenario would be greatly appreciated.

Thank you,

This message has been edited. Last edited by: Don Garland,
 
Posts: 291 | Location: Greater Cincinnati  | Registered: May 11, 2005Report This Post
Platinum Member
posted Hide Post
Hi

You could use FOCCACHE and also Format FOCUS (if the file contains for example couple of tens of thousands of records)
TABLE FILE CAR
SUM SALES RCOST
BY COUNTRY
BY CAR
ON TABLE HOLD AS FOCCACHE/DAT1 FORMAT FOCUS
END

and then in subsequent requests in different panels/pages you could create reports/graphs based on the FOCCACHE file
TABLE FILE FOCCACHE/DAT1
SUM SALES
BY COUNTRY
END

Foccache will create for each user session per IP address a dedicated caching folder/files
If the user closes hos browser than the foccache file will not be available
You can also control the time the foccache file is available within a session, so if the user doesn't close his browser for 4 hours you can define that the foccache file will be available for maximum of 2 hours within a session, for example


Yours,
Eran
SRL Products

http://www.srl.co.il

 
Posts: 97 | Location: Tel Aviv, Israel | Registered: November 20, 2005Report This Post
Guru
posted Hide Post
I played with this scenario but ultimately decided not to hold on the report server for this.

Instead, I created an indexed table on the DBMS. A scheduled, stored procedure refreshes this table, early morning. This one trip to the DB server, covers the data needs of the parameters and dop-downs for the initial Dashboard page and cut load time more than half.

Although I didn't use it, it was helpful to go through the exercise of researching the use of FOCCACHE and looking at the setting.

Thank you
 
Posts: 291 | Location: Greater Cincinnati  | Registered: May 11, 2005Report This Post
Platinum Member
posted Hide Post
Indeed, if you have a complex dashboard - the data does not change on the fly (or even it does, I've had a FOCUS table refresh every 30 seconds), not only the load time, but the stress and congestion on the database is way less. I bet on its peaking when all the workers fire up their computers in the morning... now you'll get complaints they're missing their coffee break as its too fast...


Cheers,
H.

WebFOCUS 8.1.05M
Oracle 11g - DB2
RedHat
 
Posts: 115 | Location: Brighton UK | Registered: February 19, 2005Report 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) BI Portal (8.009) data source question

Copyright © 1996-2020 Information Builders