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     Outer Join with a Dimension?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Outer Join with a Dimension?
 Login/Join
 
Moogle
Guru
posted
Hi Team,

Is there any way to setup an outer join with a dimension?

For instance, I'm joining a location table to a booking table (airline industry) in a dimension. Any report based on this dimension will show me all locations that have bookings. I want to see all locations, and see booking information next to the locations that have bookings and blanks/zeros next to the locations that don't.

Possible?

Cheers,

Joey
 
Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
<DocServices>
posted
Hi Joey,

There was an outer join feature, but it was only supported for certain types of databases. It's documented in the Join chapter (chapter 15)of Creating Reports With WebFOCUS Language 7.1(DN4500695.0905). If you are using a database that's not supported, you can use the MATCH command, which is its own chapter in the same manual (Chapter 16: Merging Data Sources).

In case you are using version 5.3, please refer to the 5.3 version of the same manual (DN4500580.0904). The information on joins is in chapter 14 and the information on Match can be found in chapter 15.

Hope this helps.

Happy New Year,
Jenn
 
Report This Post
Moogle
Guru
posted Hide Post
Hi Jenn,

I'm familiar with building joins and using the Match command when building reports. This post refers to doing this sort of thing at the dimension level. I see no way to modify the join types when building dimensions and joins in the dimension builder tool. Do you know of any way to do this?

Cheers,

Joey


-WebFOCUS 8.2.01 on Windows
 
Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
<DocServices>
posted
Hi Joey,

I checked with a product manager here and he suggested that you contact Information Builders' Customer Support Services, either call 1-800-736-6130 or access InfoResponse online. Please be ready to provide some detailed information as listed here: http://techsupport.informationbuilders.com/before_you_call.jsp.

Regards,
Jenn
 
Report 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     Outer Join with a Dimension?

Copyright © 1996-2020 Information Builders