1. Designing with Reports for Oracle Enterprise Performance Management Cloud
  2. Working with Grids
  3. Working with Drill Through and Cell File Attachments

Working with Drill Through and Cell File Attachments

Reports provides the ability to drill through to a source system and drill to cell file attachments, while viewing the report or grid in HTML preview.

Links appear in data cells where attachments are available and enabled to display by the report designer. A user can click on the link to view the source system detailed data or launch the cell file attachment. The following conditions need to be in place for drill through or file attachments to be available in Reports.

  • Drill through needs to be defined in the underlying data source (EPM Cloud source with Cloud Data Management or Fusion Applications Essbase Provider).

  • Files need to be attached to a cell at the data source, such as an EPM Cloud cell file attachment or Essbase Linked Reporting Object (LRO).

Note:

The report designer still needs to enable drill through either for the entire grid or for specific cells.

To display drill through and attachments links for all cells in the grid, where applicable:

  1. On the Grid Properties panel, next to drill through to source click Show
  2. This displays drill through to source links for any cells in the grid that have drill though definitions when the grid is previewed or if the report is opened in HTML preview.

selecting cell attachments.

To display drill through and attachments links for selected cells in the grid, where applicable:

  1. Click the cells that you want to display drill through on.
  2. On the Cell Properties panel, next to drill through to source, select the desired display setting:
    • Grid Setting (current grid setting) (default). This sets the display to whatever the current setting is for the entire grid.
    • Show
    • Hide

options for cell attachmnets in cells.

This displays drill through to source links for the selected cells in the grid that have drill through and attachments, when the grid is previewed or if the report is opened in HTML preview.