Defaulting and Disabling the Launch Method for Drill-Through Reports

The method of launching drill-through reports from Smart View can be set as default and disabled for users.

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

Note:

The task in this topic is for Service Administrators or users who are familiar with editing the properties.xml file located in the <Smart View Install>/cfg folder (for example, C:\Oracle\SmartView\cfg).

Drill-through reports can be launched either in a web browser or in a new Excel sheet. Oracle Enterprise Performance Management Cloud users can select the preferred method in the Drill-Through Launch option in the Advanced tab of Options dialog.

However, for on-premises Oracle Hyperion Planning data sources, drill-through reports can be launched only in a web browser.

Using the disableDTLaunchType property present in the Smart View properties.xml file, you can disable the selection of Drill-Through Launch options for users in the Advanced tab and default it to the web browser for supported EPM Cloud data sources.

To default and disable the drill-through launch options:

In your Smart View installation, navigate to the SmartView\cfg folder.
Make a backup copy of the original properties.xml file.
Open properties.xml for editing.

Locate the following entry:

<disableDTLaunchType>0</disableDTLaunchType>

Change the disableDTLaunchType value to 1 to make web browser as the default method for launching drill-through reports
```
<disableDTLaunchType>1</disableDTLaunchType>
```
Save the updated file.
Restart the Excel application.