Applications and reporting tools, such as spreadsheets and Report Writer interfaces, can retrieve data directly from both databases (2 in Figure 141, Hybrid Analysis Architecture). Using the dimension and member structure defined in the outline, Essbase determines the location of a member and then retrieves data from either the Essbase database or the Hybrid Analysis relational source. If the data resides in the Hybrid Analysis relational source, Essbase retrieves it through SQL commands. See Retrieving Hybrid Analysis Data.
To modify the outline, you can use Outline Editor in Administration Services to enable or disable dimensions for Hybrid Analysis on an as-needed basis. (3 in Figure 141, Hybrid Analysis Architecture). See Using Outline Editor with Hybrid Analysis and the Oracle Essbase Integration Services System Administrator's Guide.