Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer 11g Release 1 (11.1.1) Part Number B32519-02 |
|
|
PDF · Mobi · ePub |
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:
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 (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.