Drill-through reports provide spreadsheet client users direct access to data stored in a related physical data source. Drill-through reports are based on intersection levels (member sets). In a spreadsheet, users double-click the cells representing these intersection levels to view detail information that is stored in the target data source, not in the Essbase cube.
The steps to defining a drill-through report are: