OBIEE 11G Building the Physical Layer of a Repository

n this topic you use the Oracle BI Administration Tool to build the Physical layer of a repository.
The Physical layer defines the data sources to which Oracle BI Server submits queries and the relationships between physical databases and other data sources that are used to process multiple data source queries. The recommended way to populate the Physical layer is by importing metadata from databases and other data sources. The data sources can be of the same or different varieties. You can import schemas or portions of schemas from existing data sources. Additionally, you can create objects in the Physical layer manually.
When you import metadata, many of the properties of the data sources are configured automatically based on the information gathered during the import process. After import, you can also define other attributes of the physical data sources, such as join relationships, that might not exist in the data source metadata. There can be one or more data sources in the Physical layer, including databases, flat files, XML documents, and so forth. In this example, you import and configure tables from the BISAMPLE schema included with the Oracle BI 11g Sample Application.
To build the Physical layer of a repository, you perform the following steps:

• Create a New Repository

• Import Metadata

• Verify Connection

• Create Aliases

• Create Physical Keys and Joins

Create a New Repository

1.	Select Start > Programs > Oracle Business Intelligence > BI Administration to open the Administration Tool.
2.	Select File > New Repository.
3.	Enter a name for the repository. In this tutorial the repository name is BISAMPLE.
4.	Leave the default location as is. It points to the default repository directory.
5.	Leave Import Metadata set to Yes.
6.	Enter and retype a password for the repository. In this tutorial BISAMPLE1 is the repository password.
7 .	Click Next.