Workflow of Integration Services

Figure 2, Integration Services shows the Integration Services components used to prepare data for OLAP reporting through Essbase Server.

  To create Essbase databases from data sources:

  1. Build an OLAP model based on data sources.

    Integration Server stores the OLAP model and information necessary to retrieve tables in OLAP Metadata Catalog.

  2. Create a metaoutline from the OLAP model.

    Integration Server stores the metaoutline in OLAP Metadata Catalog.

  3. Use the metaoutline to load members and data into the Essbase database.

You can update the Essbase database with new members and data.