POV Manager

The Point of View (POV) is the starting point for forms, ad hoc grids, and functions.

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

On-premises data source types: Oracle Essbase, Oracle Hyperion Planning, Oracle Hyperion Financial Management

Using the POV Manager in Oracle Smart View for Office, you can change the default POV for forms and ad hoc grids, and the background POV for functions.

Note:

As a best practice, always use a private connection when working with the POV Manager. If you have already connected using a shared connection, use the Add to Private connections command to save the current shared connection as private. See Saving Connections as Private Connections.

With the POV Manager, you can perform the following operations:

  • Select members for the default POV and edit the default POV (not applicable to Financial Management)
  • Select members for the background POV for functions
  • Save a POV to a workbook
  • Copy a POV and paste it to a different worksheet or workbook
  • Edit a POV
  • Delete a POV (not applicable to Financial Management)

Video

Your Goal Watch This Video

Learn about integrating data in Office applications, including working with the POV Manager.

video icon Integrating Plan Data with Microsoft Office in Oracle Planning and Budgeting Cloud

Note:

In Essbase, if a member linked to a Smart List is in the POV, you may not be able to change some values in the Smart List for some members present in the worksheet.

For Financial Management, the last refreshed POV (either in the Financial Management web interface or in Smart View) becomes the default POV and is used by Smart View when accessing a form or ad hoc grid.

Additionally, for Financial Management, the POV Manager can only be used to set the background POV for functions.

Related Topics:

Selecting Members for the Default or Background POV

Copying and Pasting a POV

Deleting a POV