Join Properties dialog

Use this dialog to configure join properties. For example, to change the name of a join or change its cardinality (i.e. Join relationship property).

The Join Properties dialog contains two tabs:

• "General" - use this tab to configure the join. For example, to change the join name.

• "Dependents" - use this tab to look at other items dependent on this join. For example, to look at summary folders that use the join.

Note: You can use the Join Properties dialog to inspect and edit more than one join item at a time. Select a join to view its properties. If you select more than one join and make a change to a property that is common to the selected joins, the changes apply to all selected joins.

Note: Discoverer can improve query performance for end users by removing unwanted joins (also known as join trimming). For more information, see "What effect do joins have on query results and query performance?".

For more information, see:

"What are joins?"

"How to view or edit joins"

General

Name

Use this field to change the name of the join. By default, Discoverer Administrator will name the join item by combining the master and detail folder names in the form: Master Folder - > Detail Folder.

Description

Use this field to change the description of the join. By default, Discoverer Administrator will describe the join item by combining the master and detail folder names in the form: Master Folder - > Detail Folder.

Master

Use this read-only field to view the folder name at the master end of the join relationship.

Detail

Use this read-only field to view the folder name at the detail end the join relationship.

Formula

Use this field to display the "Edit Join dialog: Items tab", where you specify how the items are joined.

Outer join on

Use this field to specify an outer join on the detail or master folder. This field can display the values None, Master folder or Detail folder.

Use an outer join on the detail folder when you want to return:

• Master rows that have no corresponding detail items, as well as all matching master and detail rows.

Use an outer join on the master folder when you want to return:

• Detail rows that have no corresponding master items, as well as all matching detail and master rows. This construct is rare in real business scenarios. To use this construct, select the Detail item values might not exist in the master folder value in the Join details field. For more information, see "Edit Join dialog: Options tab".

Join details

Use this field to specify that detail items always exist in the master folder, or whether detail items might not exist in the master folder.

This field can display the following values:

• Detail item values always exists in master folder

  For more information, see the Detail item values always exist in the master folder (Typical) radio button in the "Edit Join dialog: Options tab".

• Detail item values might not exist in master folder

  For more information, see the Detail item values might not exist in the master folder radio button in the "Edit Join dialog: Options tab".

Join relationship

Use this field to specify the type of join relationship (i.e. the cardinality of the join) as follows:

• Use the One to one (1:1) join to join two tables that have a one to one relationship. For example, if every department has one (and only one) manager, and every manager can manage one (and only one) department, then you would use a 1:1 join relationship.

• Use the One to many (1:n) join to join two tables that have a one to many relationship. For example, if every employee can be in one (and only one) department, and a department can have one, many, or no employees, then you would use a 1:n relationship.

Identifier

This field displays a unique name that Discoverer uses to identify EUL and workbook objects. When matching objects common to different EULs, Discoverer uses identifiers to locate objects in different EULs that refer to the same business object.

Dependents

The Dependents tab displays two columns (i.e. Type and Name) that clarify the extent to which other objects (e.g. folders, joins) are dependent on the selected join.

Type

This column displays one or more object types (e.g. folders, items) that have a dependency on the selected join.

Name

This column displays the name of each object listed in the Type column.