Join Properties dialog

Use this dialog to configure join properties. For example, to change the name of an join or change its join relationship.

For more information, see:

"What are joins?"

The Join Properties dialog contains two tabs:

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

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

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.

Description

Use this field to change the description of the join. By default, description names are in the form: Master Folder.Item and Detail Folder.Item.

Master

Use this field to change the folder name of the master key column in the join. This value comes from the data dictionary and is not editable.

Detail

Use this field to change the folder name of the detail key column in the join. This value is supplied by the data dictionary and is not editable.

Formula

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

Outer join on

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

Use an outer join when you want to return rows for master records that have no matching detail records or for detail records that have no matching master records.

Detail item values

Use this field to specify whether detail items must always exist in the master folder. This field can display the values Always exists in master folder or Might not exist in master folder.

Join relationship

Use this field to specify the join relation. For example, from 'One to one' to 'One to many'.

Use the One to one join to join two tables that have a one to one relationship. For example to join a 'Manager' table to a 'Department' table. In this case there will only ever be a single manager for any one department.

Use the One to many join to join two tables that have a one to many relationship. For example, to join a 'Departments' table to an 'Employees' table. In this case there can be many employees in each department.

Identifier

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 objects (also known as Conceptually Identical Objects).

Dependents

The Dependents tab displays two columns (Type and Name) that clarify the extent to which other objects (folders, joins, items, item classes, summaries, conditions, calculation items etc.) are dependent on the selected join.

Type

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

Name

Displays the name of each object listed in the Type column

Notes

Using the Join Properties dialog, you can 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.