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

About Database Types in the Physical Layer


If you import the physical schema into the Physical layer, the database type is usually assigned automatically. The following list contains additional information about automatic assignment of database types:

  • Relational data sources. During the import process, some ODBC drivers provide the Siebel Analytics Server with the database type. However, 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.
  • Multidimensional data sources. Microsoft Analysis Services is the only supported XMLA-compliant data source currently available. Therefore, when you import a multidimensional data source, Analysis Services 2000 is automatically assigned as the database type and cannot be changed.
Siebel Analytics Server Administration Guide