From Spreadsheet Add-in, you can access detail-level drill-through reports that are based on the member combinations of Essbase data cells in the worksheet. Using the Drill-Through Wizard, you can also customize a predefined drill-through report.
To help you identify the cells in the worksheet with associated drill-through reports, you can set styles for cells tagged as drill-through. When you double-click a drill-through cell in the worksheet, Essbase displays the Linked Objects Browser dialog box, which displays a drill-through report entry. This dialog box also displays entries for linked partitions and other linked object types (for example, cell notes and application files). After you execute or customize the drill-through report, Essbase retrieves data from the relational source and displays the results in a worksheet.
Note: | The person at your organization who develops drill-through reports specifies whether you can customize a report and whether you must log on to Oracle Essbase Integration Services and the relational data source. |
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 in the worksheet to display all drill-through reports associated with the selected cell(s).
To open Linked Objects Browser, select Essbase, and then Linked Objects.
Alternatively, click the 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. This option works only with single-cell selection. If you select a range of cells, use the Linked Objects menu command.
Select the drill-through report entry, and then click View/Launch.
Essbase launches drill-through. If only one report exists for the selected cell(s), and if that report is not designed to be customized, drill-through generates the report and displays the results in a worksheet. The worksheet is added after the current worksheet.
If you are prompted with the Drill-Through Login to connect to Integration Server and the relational data source, enter the Integration Server name, and your database user name and password.