Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Analytics Server Administration Guide > Creating and Administering the Physical Layer in a Repository >
Process of Creating the Physical Layer for a Multidimensional Data Source
This section describes how you use the Administration Tool to add a multidimensional data source to the physical layer of a repository. Siebel Analytics uses XMLA to bring data from a multidimensional data source into the Siebel Analytics repository.
Each cube in a multidimensional data source is initially modelled as a single physical table. Cube-specific concepts such as hierarchies, levels, and properties are defined on the physical cube table.
When mapping to a multidimensional data source, you must build each element of the Physical layer, including hierarchies. No import utility is available at this time. To complete these tasks, you need to understand multidimensional data source concepts and be familiar with the structure of your data source.
NOTE: It is strongly recommended that you open your data source to use as a reference when creating the mappings between Siebel Analytics and your data source.
To help make sure that your queries return accurate data, use your data source to accomplish the following tasks:
- Understand how to fit your cube structure into the Siebel Analytics repository structure.
- Obtain information about each hierarchy that you want to access, so you can create an exact match in the Administration Tool. This includes the hierarchy name, its levels, and the properties defined at each level.
- Verify the spelling of all elements before creating the corresponding objects in the Administration Tool.
To create a physical layer for a multidimensional data source, complete the following tasks in the sequence shown:
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Analytics Server Administration Guide Published: 11 March 2004 |