Integration Services transfers data from data sources to Essbase databases. After you determine which data to transfer, you consolidate it into a form useful for decision-support users. Then you identify the tables, rows, or columns that contain the data and determine how they map to the structure of the multidimensional database.
Figure 1, Workflow for Creating an Essbase Database from a Data Source illustrates the Integration Services workflow:
Use Integration Services Console for the following tasks:
Use tables, views, and columns in one or more data source databases to create an OLAP model. An OLAP model is a logical star schema consisting of a fact table surrounded by related dimension tables.
Use the OLAP model to create a metaoutline, an template containing the structure and the rules required to generate an Essbase outline.
Use the metaoutline to create and populate an Essbase database.