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.

New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.

What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.

During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.


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
 
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
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
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
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
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
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