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] Creating Master files vs multiple holds

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Creating Master files vs multiple holds
 Login/Join
 
Geri
Platinum Member
posted
Hello,
We are upgrading and have the opportunity to improve on our process and report performance. What is the advantage of joining data sources to creating master files verses multiple hold files that pull one at a time within a single report. Basically create the entire fex as a master file verses a hold file. Both would have the same criteria as a parameterized report.

Yes, some of the joins are used in other reports but the reason for multiple reports is the uniqueness of the data provided.

The Question: Which will would be the best method to use, make all the joins as master files or join in each fex?

Thank you,
Geri Gellman

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



Prod: WebFOCUS 7.7.05 OS:Linux; Upgrading to: WebFOCUS 8.1.05 OS:Windows; Outputs: HTML, PDF, Excel; Adapters: SAP, MySQL, Oracle incl Report Caster
 
Posts: 102 | Location: Cincinnati, Oh USA area | Registered: November 02, 2006Report This Post
BabakNYC
Virtuoso
posted Hide Post
What's your DATA SOURCE? Could your specific requirements be translated into an RDBMS view?

I don't think a join in a master is any more or less efficient than a join in a fex. The benefit of having it in a master file is that it doesn't need to be repeated in the fex and that promotes consistency and makes it easier to debug and update.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Geri
Platinum Member
posted Hide Post
The Data Source is typically all SAP which has many, many tables that we must join together to get anything usable.

Not familiar with RDBMS view. Is there a manual on that option?

Thank you,
Geri Gellman



Prod: WebFOCUS 7.7.05 OS:Linux; Upgrading to: WebFOCUS 8.1.05 OS:Windows; Outputs: HTML, PDF, Excel; Adapters: SAP, MySQL, Oracle incl Report Caster
 
Posts: 102 | Location: Cincinnati, Oh USA area | Registered: November 02, 2006Report This Post
BabakNYC
Virtuoso
posted Hide Post
An RDBMS View is basically a SELECT with all the joins already coded. To WebFOCUS it'll just look like a table, but all the joins are already set up in the database and optimized. It's a way of creating an abstraction for end users to access the data without having to remember or even know what fields to use and what type of join they need.

However, if your data source is SAP, then the chances of your being allowed to create such joins is very low, which explains why you have all these hold files.

Anyways, like I mentioned, I don't think you'll see any difference in efficiency of joins in a master versus a fex. However, it's always best to have one place for all these joins for maintenance purposes which means you should in fact put them in your master file.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Geri
Platinum Member
posted Hide Post
Thanks, I just wanted to check if anyone thought one process might be better than another!

I appreciate the help.



Prod: WebFOCUS 7.7.05 OS:Linux; Upgrading to: WebFOCUS 8.1.05 OS:Windows; Outputs: HTML, PDF, Excel; Adapters: SAP, MySQL, Oracle incl Report Caster
 
Posts: 102 | Location: Cincinnati, Oh USA area | Registered: November 02, 2006Report This Post
Avinash
Platinum Member
posted Hide Post
quote:
Thanks, I just wanted to check if anyone thought one process might be better than another!I appreciate the help


Hi Geri,
below are the few steps which I follow in performance.
1. Use Cluster Join on master file. Avoid Report level join. Cluster Join creates Run time join which helps to increase report performance.
2. if you are hitting DB server multiple time for calculative date. Try to hit single time and get data into hold files and perform operation on hold file.
3. Use proper Group By, Order By and conditions. so that you can retrieve data faster.
4. And if possible use Dimensional Modelling(fact and dimensional tables ).


Thanks!
@vi

WebFOCUS 8105, Dev Studio 8105, Windows 7, ALL Outputs
 
Posts: 103 | Registered: July 08, 2013Report 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] Creating Master files vs multiple holds

Copyright © 1996-2020 Information Builders