By default, when Integration Server creates an Essbase outline, it loads, or builds, all member levels specified in the metaoutline into a multidimensional database. You can, however, set Integration Server to build to a specified member level (Hybrid Analysis) or build only to the dimension level (Advanced Relational Access). Building down to a specified level produces a smaller Essbase outline and a smaller multidimensional database. Smaller databases can be useful for users with limited disk space who do not need to see the lowest level of detail.
Integration Services uses Advanced Relational Access to give Essbase end users direct access to data from relational databases or data warehouses. This feature enables users to perform online analytical processing (OLAP) on very large data sets.
In Integration Services Console, Advanced Relational Storage is enabled at the metaoutline level. When the Relational Storage option is selected, all members of all non-accounts dimensions are automatically enabled for relational storage. Alternatively, you can enable relational storage on selected non-accounts dimensions.
When a metaoutline is enabled for Advanced Relational Access, end users are able to query directly on relationally-stored members. Essbase Server issues SQl queries to retrieve data from the database or data warehouse. All members of the dimension are accessed directly from the relational data source.