The Drill Through to Relational feature enables users to drill from a data cell or meta data label in a CubeQuery section to an existing relational query section within the same Interactive Reporting document file. Drill Through to Relational has these characteristics:
Essbase dimensions are mapped to the target relational fields, so that the member context in the Essbase query can be passed to the relational query as a filter.
Fact mapping is not available. Facts are defined in the relational query section only.
Mapping from the topic and topic items to the Essbase dimensions is done in CubeQuery. One relational query can be defined for a drill through for each CubeQuery section.
You can specify which dimension context is passed or drilled on. If a relational field is not mapped to an Essbase dimension, then context for that dimension is not be passed. Drilling on column, row or cell defines which context is passed, based on the cell’s member intersection or metadata label.
Drilling can be accomplished at any level of Essbase members in the hierarchy.
You can drill a to new or existing Results section.
Note: | The Drill to Relational feature does not include EIS Drill Through Report support, as the target relational report must exist in the same document. |