Before you create the physical layer of a repository, you need to create a repository file. For more information, see Setting Up a Siebel Analytics Server Repository.

The Physical layer of the Administration Tool defines the data sources to which the Siebel Analytics Server submits queries and the relationships between physical databases and other data sources that are used to process multiple data source queries.

NOTE:  If your organization has licensed the Siebel Analytics Platform Server Extended product or the Siebel Analytics Server Stand-Alone product, you are authorized to add databases and connection pools to the physical layer. If your organization has licensed a different product, you can only use the databases or connection pools that are provided with the product.

The first step in creating the physical layer is to create the schema. You can import the physical schema for supported data source types. You can import schemas or portions of schemas from existing data sources. Additionally, you can create the physical layer manually.

CAUTION:  It is strongly recommended that you import the physical schema.

This section provides the following topics to help you use the Administration Tool to create the physical layer of a repository:

• Process of Creating the Physical Layer From Relational Data Sources
• Process of Creating the Physical Layer From Multidimensional Data Sources
• Setting Up Database Objects
• Setting up Connection Pools
• About Physical Tables
• Creating and Setting Up Physical Tables
• Creating Physical Layer Folders
• About Physical Joins
• Defining Physical Foreign Keys and Joins
• Using Database Hints