Siebel Analytics Server Administration Guide > Creating and Administering the Physical Layer in a Repository > Setting Up Database Objects >

Creating a Database Object Manually in the Physical Layer

If you create a database object manually, you need to manually set up all database elements such as connection pool, tables, and columns.

NOTE:  For multidimensional data sources, if you create the physical schema in the physical layer of the repository, you need to create one database in the physical layer for each cube, or set of cubes, that belong to the same catalog (database) in the data source. A physical database can have more than one cube. However, all of these cubes must be in the same catalog in the data source. You specify a catalog in the Connection Pool dialog box.

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

To create a database object

1. In the Physical layer of the Administration Tool, right-click and select New Database from the shortcut menu.

   Make sure that no object is selected when you right-click.

2. In the General tab, complete the necessary fields.
   1. In the Name field, type the name you want to assign.
   2. From the Database drop-down list, select the appropriate database type.
3. Click the Features tab to examine the SQL features supported by the database type specified in Step 2.