Siebel Analytics Server Administration Guide > Creating and Administering the Physical Layer in a Repository > Process of Creating the Physical Layer From Multidimensional Data Sources >

Importing a Physical Schema From Multidimensional Data Sources

This topic is part of Process of Creating the Physical Layer From Multidimensional Data Sources.

Siebel Analytics uses XMLA to import data from a multidimensional data source into the Siebel Analytics repository. During the import process, each cube in a multidimensional data source is created as a single physical cube table. Siebel Analytics imports the cube, including its metrics, dimensions and hierarchies. After importing the cubes, you need to define the properties of the cube-specific concepts such as hierarchies, levels, and properties on the physical cube table before they can be used.

CAUTION:  Although you can create a physical schema from a multidimensional data source, it is strongly recommended that you import it.

• Microsoft Analysis Services is the only supported XMLA-compliant data source currently available.
• Analytics only imports the dimensions and hierarchies that are supported by Siebel Systems. Therefore, if a cube has a ragged hierarchy or a parent-child hierarchy, it will not be imported.
• It is recommended that you remove hierarchies and columns from the physical layer if they will not be used in the business model. This eliminates maintaining unnecessary objects in the Administration Tool and might result in better performance.

To import a physical schema from multidimensional data sources

1. In the Administration Tool, select File > Import from XMLA.
2. In the Import From XMLA dialog box, in the URL field, type the URL for the Web service that acts as the XMLA provider.

   Obtain the URL connection string from your Microsoft Analysis Services Administrator.

3. In the username and password fields, type a valid username and password for the data source.

   The administrator must supply the user name and password for the data source.

4. Click Ok.

   The Administration Tool connects to the destination source to obtain a list of the available data catalogs (databases).

5. In the second Import From XMLA dialog box, expand the data source and catalog (database), if necessary, and select the catalogs (databases) or cubes to import.

   The OK button is unavailable until you select a downloadable object.

6. After you select all the objects you want to import, click OK.