1. Working with Oracle Smart View for Office (Mac and Browser)
  2. Reports
  3. Importing and Working with Fully Formatted Reports
  4. Changing the POV in Reports

Changing the POV in Reports

You can change the POV in a report.

Note:

Before you begin:

  • You should have completed steps 1 through 3 (and, if you're working with prompts, step 4) in Importing and Working with Fully Formatted Reports

  • Save the workbook if there are changes that you want to keep. The workbook will be closed and regenerated when you edit the POV.

To change the POV in an imported report.
  1. Click the Edit POV button in the Smart View ribbon:

    This launches the Edit POV panel:

    edit pov main panel

    Use the drop-down arrow in each field to locate drop-down menus indicating that the dimension POV can be changed.

    edit_pov_panel

  2. If the drop-down list contains a fixed list of options, select an option from the list.
  3. Click drop-down list to open the member selection.

    In the example in step 1 , the Year dimension contains a select option.

  4. Click Reload Report.

    The formatted report is regenerated using the updated POV.