To access drill-through reports from Spreadsheet Add-in:
Locate a drill-through cell as indicated by its style.
Select one cell or a continuous range of cells from the same parent in the worksheet to display all drill-through reports associated with the cell you select.
For Integration Server to return a drill-through report when multiple cells are selected, all members selected for multiple-cell drill-through must come from these locations: |
Select Essbase, and then Linked Objects.
If you are selecting one cell, you may alternatively select Enable Linked Object Browsing in the Essbase Options dialog box (Global page), which enables you to double-click a linked object cell to open Linked Objects Browser.
Select the drill-through report, and then click View/Launch.
Essbase launches drill-through. If only one report exists for the selected cells, and if that report is not designed to be customized, drill-through generates the report and displays the results in a spreadsheet. The worksheet is added before the current worksheet.
If you are prompted by the display of the Drill-Through Login to connect to Integration Server and an SQL data source, enter the Integration Server name and your database user name and password.
If multiple reports exist for the cell or cell range that you select, follow the steps in Selecting Reports to View or Customize to select a report.