Join Properties dialog

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

The Join Properties dialog contains two tabs:

"Join Properties dialog: General tab" - use this tab to configure the join. For example, to change the join name.
"Join Properties dialog: Dependents tab" - 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"

Join Properties dialog: General tab

Use this tab to configure the join.

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.

Note: This field becomes read-only if the Auto generate name property is set to Yes.

Auto generate name

Use this field to change the value of the Auto generate name property to Yes or No. When the Auto generate name property is set to Yes, Discoverer enables the names of some types of Joins to be automatically updated whenever a folder or item name (used in this join) is changed.

For more information about this property, see "About generating and updating EUL item names automatically".

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, and 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, and 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) option 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 option in the "Edit Join dialog: Options tab".

Join relationship

Use this field to specify the type of join relationship ( 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.

Warning: It is not advisable to change an identifier as it can affect the relationships between EUL objects.

Automatically save changes after each edit

Use this check box to save changes each time a field in this dialog is updated.

Join Properties dialog: Dependents tab

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

Type

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

Name

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