Hybrid Analysis and Drilling (Essbase and DB2 only)

When you drill down to retrieve Hybrid Analysis data, the drill down retrieves only the next level of information, even if there is a selection made for “Drill Through”, or the "Drill to all Levels" or "Drill to Lowest Level" options have been enabled on the OLAP Query Options dialog.

If you can drill into data returned by way of hybrid analysis, Interactive Reporting adds a “dummy” level to the data layout called "Hybrid1" and displays the new Level of data accordingly in the Contents Pane. If data is not retrieved successfully from the Essbase servers, you get the message: "No more levels to drill into" message. If you continue to drill down on the Hybrid Analysis level of data, each successful drill down returns the data as "Hybrid2" in the data layout (and "Hybrid3", "Hybrid4"… etc. for any subsequent Hybrid Analysis Level retrievals).

You can use drill up on Hybrid Analysis data to redisplay that level as the lowest level in the Contents pane. All lower level Hybrid Analysis data is removed from the Contents pane and data layout.