Hybrid Analysis Relational Source

The initial step in setting up Hybrid Analysis is to define the relational database as a Hybrid Analysis relational source (1 in Figure 141, Hybrid Analysis Architecture).

You define the Hybrid Analysis relational source in Integration Services Console. Through Integration Services Console, you first specify the relational data source for the OLAP model. The OLAP model is a schema that you create from tables and columns in the relational database. To build the model, Integration Services accesses the star schema of the relational database (a in Figure 141, Hybrid Analysis Architecture).

Using the model, you define hierarchies and tag levels whose members are to be enabled for Hybrid Analysis. You then build the metaoutline, a template containing the structure and rules for creating the Essbase outline, down to the desired Hybrid Analysis level. The information enabling Hybrid Analysis is stored in the OLAP Metadata Catalog, which describes the nature, source, location, and type of data in the Hybrid Analysis relational source.

Next, you perform a member load, which adds dimensions and members to the Essbase outline (b in Figure 141, Hybrid Analysis Architecture). When the member load is complete, you run a data load to populate the Essbase database with data (c in Figure 141, Hybrid Analysis Architecture). At this point, the Hybrid Analysis architecture is in place: