Drill-Through Reports

Data source types: Essbase, Planning, Financial Management

You can drill through to the detailed data in a database as follows:

If you are connected to Planning or Financial Management via Smart View, you can use the drill-through capabilities of Smart View to drill through your Planning or Financial Management application to detailed data in Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications or Oracle Hyperion Financial Data Quality Management, Fusion Edition data sources.
For applications created in Oracle Essbase Administration Services, you can drill through to Oracle General Ledger.
For applications created in Oracle Essbase Studio or Oracle Essbase Integration Services, you can drill through to relational databases. For applications created in Oracle Essbase Studio, you can also drill through to administrator-configured URLs.

Predefined by administrators, drill-through reports are available to users from specified individual member cells and data cells. A cell can be associated with multiple drill-through reports. Cells that contain drill-through reports can be indicated on the grid by a cell style (see Cell Styles).

The data displayed in a drill-through report is dynamic.

Note:

You cannot use alias tables for drill-through; you must use member names.

To access a drill-through report:

Select a member or data cell associated with a drill-through report (a tooltip displays a list of available drill-through reports when you mouse over a cell.)
From the data source ribbon, select Drill-through Reports to display the list of reports associated with the cell.
Select a report and click Launch.