Setting the Drill-Through Launch Option

Specify your drill-through launch preference: drill-through to a web page, or drill-through to an Excel sheet.

Data source types: Planning, Planning Modules, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Tax Reporting

When connected to a supported Oracle Fusion Cloud Enterprise Performance Management service and using Data Integration to load data for drill-through reports, you can launch the reports in a browser or on a new Excel sheet.

Specify your launch preference using the Drill-Through Launch option, located in the Options dialog. Advanced tab.

To specify your drill-through launch preference:

In the Smart View ribbon, select Options, and then Advanced.
For Drill-Through Launch, select your preferred launch method:
- In Web Browser—Always launch in a browser
  
  Note:
  
  Always select this option for Oracle Hyperion Planning data sources as drill-through reports from Oracle Hyperion Planning can be launched only in a web browser, and not in a new Excel sheet. This option may appear selected by default and not editable for you, based on the configurations set by your administrator.
- In New Sheet—Always launch on a new Excel sheet
- Prompt Me to Choose Target—Prompt me to choose browser launch or Excel sheet launch at runtime
Click OK.

Note:

Advanced options are global options. Changes to global options become the default settings for all existing and new worksheets and workbooks so it is not necessary to use Save as Default Options or Apply to All Worksheets with global options.
Launch a drill-through report, as described in Accessing Drill-Through Reports