Oracle® Business Intelligence Server Administration Guide > Creating and Administering the Physical Layer in an Oracle BI Repository >
Process of Creating the Physical Layer from Relational Data Sources
Importing the physical schema saves you time and effort by importing the structure for the physical layer. You can import schema for supported data sources. If you do not import the schema, you must create each table, primary key, foreign key, and any other objects against which you want to generate queries. Data from these sources can be displayed on an Oracle BI Interactive Dashboard. The following is a list of tips to help you when importing a physical schema:
NOTE: Data Warehouse (OLAP) objects are stored in and accessed through Oracle Analytic Workspaces (AWs). For information about how to extract these objects, refer to the Oracle Reference 10g Release 2 documents from the oracle.com Web site.
To create the physical layer by importing the schema, complete the following tasks in the sequence shown:
|