Detailed data that is stored in OLTP databases should be loaded into core data warehouses and then the structure of the cubes should be created in multidimensional source databases. In our case this source will be based on Essbase Server.
Oracle Business Intelligence Enterprise Edition Server can be configured to connect to these multidimensional sources including Essbase Servers. We're not going to discuss how to build a cube in this recipe. We're going to learn how to create a repository based on the Essbase source.
We're going to use BI Administration Tool to import multidimensional source metadata to the Physical layer of the repository. When you click on the Import Metadata option from the File menu, the Import Metadata wizard will pop up. We'll have to select the Connection Type option as Essbase and the server name where Essbase is installed and configured. Additionally, User Name and Password should be entered in order to access...