Oracle9i Discoverer Administrator Administration Guide Version 9.0.2 Part Number A90881-02 |
|
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 may differ from those generated by Discoverer.
This dialog is also displayed as:
For more information, see "Creating summary folders manually"
Use the Select button to display the "Choose user or table/view dialog", where you select a table within the current database.
Use the drop down menu to select the business area that you want to map to the external summary table.
Use the list box to map EUL items (for the current business area) to corresponding database columns in the external summary table (displayed in the Mapped Items list box).
Map items in one of the following ways:
Drag an item from the Available items list into the corresponding database column in the Mapped items list.
Drag a folder from the Available items list box into the Mapped Items list box.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.
Select a database column in the Mapped items list and a corresponding item in the Available items list and click the include button (right arrow) and Discoverer matches both in the Mapped items list
Select an database column in the Mapped items list and then double click the corresponding item in the Available items list
The database columns in the external summary table mapped to corresponding items in the EUL
|
Copyright © 2002 Oracle Corporation. All Rights Reserved. |
|