Versions Compared

Version Old Version 1 New Version Current
Changes made by

Matija Lukic (Deactivated)

Matija Lukic (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Starting with version 21.1.0, when opening the report, it is possible to pass the initial POV values, by adding more parameters to the URL.
This will enable you to pass POV context (e.g., from another solution) to a CXO report, thus ensuring a better user experience when users need to navigate between multiple reporting solutions.This page explains the format and the limitations of passing initial POV in the CXO report URL.

Summary

Normally, the URL to open a report is <hostname>/report/<report-number>.
For example https://company.training.cxosoftware.com/report/93

To pass a POV in the report URL, add i URL query parameter initialPov=<dimension>:<value>;<dimension>:<value>.
For example https://company.training.cxosoftware.com/report/93?initialPov=YER:2010;PER:Jan
Opening this URL will show the data from the desired year and period.

...

The standard format of the URL parameter is initialPov=<dimension>:<value>;<dimension>:<value>
Example: https://company.training.cxosoftware.com/report/93?initialPov=YER:2010;PER:Jan

  • Dimension: corresponds to the CXO dimension code, such as YER, PER, ENT, CAT, or ACC. List of all dimension codes can be seen, for example, in CXO Designer > Tools > Source system defaults

  • Value: corresponds either to desired POV member name or member description

  • Delimiters: by default a colon (:) and semicolon (;). If your member names or member descriptions contain these delimiters, it’s a good idea to change them CXO Configurator > Settings panel

    • POV overrides in URL: Array delimiter separates initial values for different POV dimension. Default value: semicolon (;)

    • POV overrides in URL: POV value delimiter separates a POV dimension from its value. Default value: colon (:)

...

In a CXO report, each member has name and a description. When searching or changing POV, member descriptions are shown.
Member names are unique within that dimension, member descriptions don’t have to be unique.

The POV values in the URL are matched exactly either to a member name or a member description.

What is being matched is controlled with another URL parameter: initialPovValueSearchType.
Possible values:

  • description: member with the description equal to passed POV value is selected. If no members match this condition, then a member with the name equal to the passed POV is selected. If multiple members match this condition, the first one is selected.

    • Example: https://company.training.cxosoftware.com/report/93?initialPov=ENT:Europe&initialPovValueSearchType=description
      first looks for a member with description “Europe“ in Entity dimension, and if not found, member with name “Europe“

  • name:

    • Example: https://company.training.cxosoftware.com/report/93?initialPov=ENT:EU;YER:2020&initialPovValueSearchType=name
      looks for a member with name “EU“ in Entity dimension, and member with name “2020“ in Year dimension

...

  • Passing POV via URL parameters is only possible for URLs to reports (i.e., /report/<report-number/). For storyboards or conversations that is not possible.

...