Retrieving Hybrid Analysis Data with Spreadsheet Add-in
Use the Enable Hybrid Analysis option in the Essbase Options dialog box in Spreadsheet Add-in to drill down to members in the Hybrid Analysis relational source.
See Oracle Essbase Spreadsheet Add-in User's Guide, Oracle Essbase Spreadsheet Add-in User's Guide.
Hybrid Analysis supports the following options in Spreadsheet Add-in:
Drill-down:
For best performance, use children, bottom-level, or siblings zoom-ins; avoid descendents zoom-ins.
Drill-up: Parent drill-up
The drill-up on a relational member always takes you to the leaf-level member in the Essbase outline, and not to the immediate parent of the relational member.