Understanding How Drill-Through Works

             Drill-through is the ability to navigate from your intersection in an Essbase reporting environment to data found in another source. Essbase Studio passes your current context to the other data source. When you drill into the cell at the intersection of Row and Column, Oracle Hyperion Smart View checks for the existence of a drill-through report for this data cell and finds one for Supplier detail. When the report is launched, the context of the data cell is passed into a SQL statement. 

Essbase Studio supports the following sources for drill-through reports:

• Relational sources
• URL, standard (manual) or within the template for Oracle Hyperion Financial Data Quality Management (FDM) or for Oracle BI EE.
• Custom SQL.
• Java method

Creating a Drill-Through Report:

     To create a drill-through report, follow these steps:

1. In the Metadata Navigator, right-click the Drill Through Reports folder and select New | Drill-through Report.
2. Specify a name for the report.
3. In the Intersections area, click Add.
4. Expand sales analysis and Hierarchies.
5. Select Product, and then click OK.
6. Change the intersection level to be only Family.
7. Select the Report Contents tab.
8. Add the columns to the reports by dragging and dropping from either the Data Sources area or the Metadata Navigator.
9. Select the Associations tab.
10. Select sales analysis model, and then click Save.
11. Select the Report Contents tab.
12. Deselect Show Duplicates in Report, and then click Test.
13. Click Close twice.

The report is now available.