MENU
    Point of View
    • 4 Minutes to read
    • Dark
    • PDF

    Point of View

    • Dark
    • PDF

    Article summary

    What is Point of View (POV)

    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.

    If you apply the Point of View (POV) setting to a dimension and save the report, the applied POV setting is retained when you navigate to another page or login to the application the next time.

    When you open a shared report with POV settings defined by another user, the report is displayed with the applied POV setting.

    Note:
    If you are a read-only user, you can change the POV setting while running the report, but when you navigate to another page or login to the application the next time the changes will not be saved.

    The Apply/Remove POV setting on the report is retained:

    • When you Save As or Copy a report.

    • In a Dimension based report and reports with Substitution Variables on the Page axis.

    Note:
    POV setting saved is only at the corresponding artifact level. The POV setting applied on a Dynamic Report is not carried forward to the Report Collection. Report Collection containing this report will run without POV settings unless you apply te POV setting on Report Collection.

    How to Apply POV to a Report

    1. Click Apply POV form the toolbar of a Dynamic Report, Report Collection or Financial Package Publisher.

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

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

    How to Set Up POV

    1. Navigate to Maintenance > Reports > Point of View.

    2. Select the reporting area.

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

    4. Click Save.

    Note:
    Available POV scenarios are based on whether the Copy Scenario Security to Report Security option is selected on the Dimension Security Configuration page.

    Use Case 1

    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 2

    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.

    Order of Priority for Member Selections

    The table 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.


    Page Dimension with selections

    Page Dimension without selections

    Reporting Artifact

    With POV

    Without POV

    With POV

    Without POV

    Dynamic Report

    POV>Dynamic Report

    Dynamic Report selections

    POV>Default members

    Default members

    Financial Package Publisher

    POV>Financial Package Selections> Dynamic Report Selections

    Financial Package selections>Dynamic Report selections

    POV>Financial Package selections>Default members

    Financial Package selections>Default members

    Templates (if Dynamic Report is run from the Planning Control Panel)

    Entity combination>Control panel selections >Dynamic Report selections

     

    POV Is not applicable

    Entity combination>Control panel selections >Dynamic Report selections

    Entity combination>Control panel selections>Default members

     

    POV Is not applicable

    Entity combination>Control panel selections>Default members

    Report Collection

    Bursting selections> Report Collection selections>POV> Dynamic Report selections

    Bursting selections> Report Collection selections> Dynamic Report selections

    Bursting selections> Report Collection selections>POV> Default members

    Bursting selections> Report Collection selections> Default members

     

    Dimension not used in report

    Page Dimensions with Pick List applied

    Reporting Artifact

    With POV

    Without POV

    With POV

    Without POV

    Dynamic Report

    POV>Default members

    Default members

    Pick List selections>POV>Dynamic Report selections >Default members

    Pick List selections>Dynamic Report Selections >Default members

    Financial Package Publisher

    POV>Default members

    Default members

    POV>Financial Package selections>Dynamic Report selections>Default members

    Financial Package selections>Dynamic Report selections >Default members

    Templates (if Dynamic Report is run from the Planning Control Panel)

    Entity combination>Default members

     

    POV Is not applicable

    Entity combination>Default members

    Pick List selections (as selected from Templates interface)>Entity combination>Control panel selections >Dynamic Report selections >Default members

     

    POV Is not applicable

    Pick List selections>Entity combination>Control panel selections >Dynamic Report selections >Default members

    Report Collection

    Bursting selections> >POV> Default members

    Bursting selections> > Default members

    Bursting selections> Report Collection selections>POV> Dynamic Report selections>Default members

    Bursting selections> Report Collection selections> Dynamic Report selections>Default members

    What to do if the Report Total Errors When POV is Applied or Removed

    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.


    Was this article helpful?