Using External Tables dialog

Use this dialog to map an external database table to the End User Layer (EUL). Run the Summary Wizard once for each external table you want to register.

External summary folders reference tables created with an application external to Discoverer. The column and item names might differ from those generated by Discoverer.

This dialog is also displayed as:

Summary Wizard: Step 3 dialog

For more information, see "Creating summary folders manually"

Select an external summary table

Use the Select button to display the "Choose user or table/view dialog", where you select a table within the current database.

Available Items

Use the drop down list to select the business area that you want to map to the external summary table.

Use the field to map EUL items (i.e. for the current business area) to corresponding database columns in the external summary table displayed in the Mapped Items field.

Map items in one of the following ways:

• Drag and drop

  Drag an item from the Available items field into the corresponding database column in the Mapped items field.

  Drag a folder from the Available items field into the Mapped Items field to map all the columns in the external summary table to End User Layer items in a single operation. Discoverer automatically matches the items of similarly named database columns in the external summary table. Repeat this procedure for multiple folders if the external summary table maps to items in more than one folder in the EUL.

• Include button

  Select a database column in the Mapped Items field and a corresponding item in the Available items field and click the include button (right arrow) and Discoverer matches both in the Mapped Items field.

• Double click

  Select an database column in the Mapped Items field and then double click the corresponding item in the Available items field.

Mapped Items:

The database columns in the external summary table mapped to corresponding items in the EUL

• Item

  The item in the EUL mapped to a corresponding database column in the external summary table.

• Database Column

  The database column in the external summary table mapped to a corresponding item in the EUL.

• Datatype

  Data type and size of the database column.