Accessing Drill-Through

  To access drill-through reports from Spreadsheet Add-in:

  1. 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.

    Note:

    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:

    • The same physical table and column in the relational source database

    • The same member level in the underlying OLAP metaoutline

    • The same hierarchy.

      A multiple-cell drill-through operation is valid only if all three criteria noted above are met. A message is displayed if the combination of cells you select is invalid for performing a multiple-cell drill-through operation.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

    Note:

    An administrator at your organization develops drill-through reports and specifies (1) whether you can customize the report, and (2) whether you must log on to Integration Services and the relational data source.

Related Topics

Customizing Reports with Drill-Through Wizard

About Drill-Through