Bookshelf Home | Contents | Index | Search | PDF

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

Creating a Database Object in the Physical Layer

---

The way you create a database object depends on whether you imported your schema or created it for a multidimensional data source.

• If you import the physical schema into the Physical layer, the database type is automatically assigned. During this import process, some ODBC drivers provide the Siebel Analytics Server with the database type. If the server cannot determine the database type, an approximate ODBC type is assigned to the database object. Replace the ODBC type with the closest matching entry from the database type drop-down menu.
• If you create the physical schema in the physical layer of the repository for a multidimensional data source, you need to create one database in the physical layer for each cube, or set of cubes, that belong to the same catalog (or 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 XMLA tab of the Connection Pool dialog box.

  NOTE:  Note: if multiple cubes share dimensions, each shared dimension and hierarchy must be repeated for each physical cube table.

  Before you begin, contact your system administrator to obtain vendor-specific information about your data source. Make sure to ask the following questions:

  • Are your database entries case sensitive?
  • Obtain values for setting up your connection pool. How should you connect to your data source? For example, you might obtain the URL to connect to the data source provider (this is input as the connection pool data source name) and the parameters necessary for connecting or accessing the data source (this is added in the XMLA tab of the Connection Pool dialog box).

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.
4. Click the Display Folders tab to see display folders created by the administrator.

Bookshelf Home | Contents | Index | Search | PDF