About Drill Through Reports

When you want more information than what you can see in the Essbase cube, you can use drill through reports to access external data sources.

Drill through refers to linking the Essbase cube to further data, for example, transactional-level data stored in a relational database.

You can drill through to data from any other Oracle application, an external database, a file (delimited or Excel), or a URL-based target.

You can also select multiple cells or multiple ranges of cells, and see the merged results in drill through. Selections can be recursive, non-recursive, level 0, or non-contiguous. URL drill through is not supported for multiple cell selection.

You can create drill through reports in the Essbase interface or generate them using Smart View. You can also do a URL-based drill through from Smart View, by opening the URL provided in the report, in a browser.