Changing the POV in Reports

You can change the POV in a fully formatted report.

Note:

Before you begin:

• You should have imported the report as described 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 Oracle Smart View for Office ribbon:
   

   This launches the Select POV dialog:

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

   Edit POV reloads the formatted report.

2. If the drop-down list contains a fixed list of options, select an option from the list.
3. If the drop-down list contains a ellipsis option, :
   1. Click to open the Member Selection dialog.

      In the following example, the Entities dimension contains an option.

      
      
      
   2. In the left pane of the Member Selection dialog, expand the members where necessary, then select a member and click to move it to the right pane, and then click OK.

      Note:

      Only one member from the current dimension can be selected at a time. To select a member from a different dimension, you must exit Member Selection and then select a different dimension in the Select POV dialog.

      Note:

      The designer of your report specifies during POV definition whether the drop-down list is static or contains a Select option indicating that member selection is allowed for the POV (described in Defining the Grid Point of View in the Designing with Reports for Oracle Enterprise Performance Management Cloud ).

   3. Repeat step a and step b for each member that you want to add to the drop-down member selector list.

      To choose members from another dimension, locate another dimension containing a Select option in the drop-down list and repeat step a and step b for each member that you want to add to the drop-down member selector list for the dimension.

4. Perform an action in the Select POV dialog:

   • Click OK, taking the newly-selected member as your POV selection.

   • Click the drop-down menu and select any of the available members from the list, including the newly-added member, and then click OK.

   The formatted report is regenerated using the updated POV.