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:
The lower-level members and their associated data remain in the relational database.
The data in the relational database is mapped to the Essbase outline that is defined by Hybrid Analysis.
The outline resides in the Essbase database.
Metadata is data that describes values within a database. The metadata that defines the Hybrid Analysis data resides in the Essbase outline and in the Integration Services metaoutline on which the Essbase outline is based. Any changes that are made to Hybrid Analysis data in an OLAP model or metaoutline that is associated with an Essbase outline must be updated in the outline to ensure accuracy of the data reported in Essbase. See Managing Data Consistency in Hybrid Analysis.
Upper-level members and their associated data reside in the Essbase database.