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

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

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

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