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 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.
If you want to display a list of available drill-through reports whenever you mouse over a cell, select Display Drill Through Report ToolTips on the Advanced page of the Options dialog box.
From the data source ribbon, select Drill-through to display the list of reports associated with the cell.