Point of View

Point of View (POV) is a setting for each dimension that controls data displayed in a report. It is a user-specific method of modifying the page level settings to desired dimension members.

The modification may be to narrow or widen the scope of the page level settings. POV is for Financial Reports, Dynamic Reports, Report Collections, and Financial Package Publisher. 

1. Click More > Apply POV for a selected report in the File Cabinet.

2. Run the report. POV selections are applied at runtime.

3. POV will be reflected for page level dimensions in the report.

1. Navigate to Maintenance > Reports > Point of View. Select the reporting area.

2. Click the Search button to select dimension members for each dimension listed.

3. Click Save.

In Practice

Let's say you have a report with dimensions used in the header and footer section of the report. Then, you apply POV to those dimensions. This results in POV member selections displayed in the header and footer sections of the Dynamic Report. If you apply POV on a dimension member selection for a page axis in the layout area, the original dimensions will still be displayed, but the report will run with the POV selections.

Use Case

Let's say Company and Location dimensions are used on the page axis for a Balance Sheet report. User X applies POV for the Balance Sheet report. Originally in the Dynamic Report Member Selections, Canada is selected for the Company dimension and Alberta for the Location. However, user X selects British Columbia for Location. When user X runs Balance Sheet, POV is applied resulting in output for Canada and British Columbia. However, if the same report is run by user Y (who does not have POV applied), the result is output for Canada and Alberta.

The table below provides the order of priority applied for member selections on page dimensions in different reporting artifacts when executed. For example, POV > Dynamic Report means the system will apply user POV selections (if POV is applied on the report and if member selections exist in the POV) for the specific page dimension. If POV is not applied or POV selections don’t exist on the page dimension, then the system applies the member selections made in the Dynamic Report Member Selector interface.

If a report uses the Sum function to display the totals and then POV is applied to the Report, the Sum function in this POV applied report will not display correctly and will instead display a red exclamation mark and the message, "Data cannot be displayed as the member(s) used in the formula do not exist in the report". This happens as the Sum function tries to calculate the total based on the rows in the original report and as there will be some missing rows, it fails. This will also happen in case any other function like Average or Count is used within the report by using the Edit Formula option

So, if the report is returned to its original state by applying or removing POV, then the functions will calculate correctly. In case it is required that the functions correctly calculate in the POV applied report, then the workaround is to click the Edit Formula option from any cell which displays the red exclamation mark and the row selection needs to be made again before clicking OK.