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.