Retrieving Data from Relational Sources

Because relational databases can store several terabytes of data, they offer nearly unlimited scalability. Essbase multidimensional databases are generally smaller than relational databases but offer sophisticated analytical capabilities. With Hybrid Analysis, you can integrate a relational database with an Essbase database and leverage the scalability of the relational database with the conceptual power of the multidimensional database.

Hybrid Analysis eliminates the need to load and store lower-level members and their data within the Essbase database. This feature gives Essbase the ability to operate with almost no limitation on outlines sizes and provides for rapid transfer of data between Essbase databases and relational databases.

  To retrieve data that is stored in the Hybrid Analysis relational source:

  1. Select Essbase, and then Options.

  2. In Essbase Options, select Zoom.

  3. Select Enable Hybrid Analysis.

    This option enables you to retrieve data from the Hybrid Analysis relational source.

    Note:

    If the outline contains multiple levels of Hybrid Analysis members, a zoom out operation on the bottom level Hybrid Analysis member takes you to the Essbase parent member, thus bypassing all other Hybrid Analysis levels.

  4. Click OK.

  5. Select Essbase, and then Retrieve, to retrieve the data.