Viewing the Drill-Through Report Source POV

View information about the source POV of a drill-through report by accessing the Sheet Information dialog.

Cloud data source types: Planning, Planning Modules, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Tax Reporting

Use the Sheet Info command in the Smart View ribbon to view details about the cell intersection and POV of the cell from which the drill-through report was launched.

To view the source POV of a drill-through report launch cell:

1. Ensure that you have enabled drill-through launch on to a sheet.

   In the Options dialog, Advanced tab, you should select either In New Sheet or Prompt Me to Choose Target. For more information, see Setting the Drill-Through Launch Option.

2. Launch a drill-through report on to a new sheet, as described in Accessing Drill-Through Reports.
3. Select the Smart View ribbon, and then select Sheet Info.

   The POV of the intersection of the drill-through launch cell is shown in the Sheet Information dialog box. In the example POV shown in Figure 7-27, we see these information categories related to the cell intersection:

   • Row members

   • Column members

   • POV members

   • Page members

   We also see a General section showing that we we're working with a drill-through sheet.

   Figure 7-27 Sheet Information Dialog Showing POV for Drill-Through Launch Cell

   
   
   

   Note:

   In Oracle Smart View for Office ad hoc mode, when drill-through is launched, the POV section of Sheet Information dialog shows the member names corresponding to the alias table selected on the ad hoc sheet.

4. Optional: Click Save to save the POV information in a separate sheet in the workbook.

   Tip:

   As a best practice, copy and paste the POV information from the new sheet to a permanent file for your own reference.