New Join/Edit Join dialog

Use this dialog to create a new join, or edit an existing join.

This dialog is also displayed as:

New Join dialog

Edit Join dialog

For example, to display information from both the Product folder and the Sales Facts folder, you might create the following join on the shared field Product Key:

Products.Product Key = Sales Facts.Product Key

For each record in the Sales Facts folder, this would allow you to display information about the product being sold that is stored in the Product folder, not in the Sales Fact folder. For example, description, price, and storage location.

For more information, see:

"What are joins?"

Master folder

Use this drop down field to select the item in the master folder that you want to join. Fields are prefixed with the folder name, for example Products.Product Key.

• Choose 'More items' to display the "New Join dialog (Choose folder)", where you can select an item from anywhere in the EUL.

Operator

Use this drop-down list to select how you want to match the two items. For example, choose '=' to find an exact match between two items. For more information, see the list of join operators below.

Table 25-3 Join Operators

Operator	Description
=	equijoin, combining rows that have equivalent values for specified items
< >	not equal
<	less than
<=	less than or equal
>=	greater than or equal
>	greater than

Detail Folder

Use this drop down field to select the item in the detail folder that you want to join. The detail item can be in a folder in either the same business area as the master item, or in a folder in a different business area. Fields are prefixed with the folder name, for example Sales Facts.Product Key.

• Choose 'More items' to display the "New Join dialog (Choose folder)", where you can select an item from anywhere in the EUL.

Name

Use this field to enter the name of the join. This name is displayed in the Discoverer Administrator Workarea, and is used by Discoverer end users when they use workbooks.

Description

Use this field to enter additional information about the join. This description is displayed in the Discoverer Administrator work area, and is used by Discoverer end users when they use workbooks.

Multi-item

Use this button when you want to create more than one join criterion. Here, you display additional fields and buttons used to create multi-item joins (see "New Multi-Item Join dialog").

Options

Use this button to display the "Join Options dialog", where you configure outer joins.

Master to Detail

Text description of the illustration join12m.gif

This icon represents the one-to-many relationship between the two items in different folders in the master to detail join relationship. The master item is on left and the detail item is on the right.

Detail to Master

Text description of the illustration joinm21.gif

This icon represents the many-to-one relationship between the two items in different folders in the detail to master join relationship. The detail item is on the left and the master item is on the right.

For more information, see Chapter 10, "How to edit joins".