1. Designing with Reports for Oracle Enterprise Performance Management Cloud
  2. Defining Members
  3. Assigning Members
  4. Assigning Members Using Functions
  5. Example: Using the Match function with CurrentPOV

Example: Using the Match function with CurrentPOV

The Match function allows selecting members that match a specified pattern or set of characters. The CurrentPOV function returns the selected member from the POV for a dimension.

You can append the Match string with the Current POV selection as either a prefix or suffix by setting Include CurrentPOV to either Member Name as prefix or Member Name as suffix. The default setting is No.

This example shows how the combination of Match and CurrentPOV can be used with a modified Oracle Essbase Sample Basic cube with alternate hierarchies for JanYTD, FebYTD, …DecYTD in the Year dimension.

This allows you to select a month for the CurrentPOV for the Years dimension and have its related YTD member selected. For example, selecting Aug and having AugYTD returned.

Here is the modified Essbase Sample Basic cube Year dimension.


Essbase Year Dimension

With the following grid design with the Measures dimension Descendants of Profit (Inclusive) in the row and Year in the columns set to:

  • CurrentPOV – to display the month selected in the POV.

  • Members matching YTD with CurrentPOV as the prefix.


Grid Displaying the Match function

For column B, in the member selector under Functions with the Match function selected:

  • Enter a Search string of YTD.
  • Set the Include CurrentPOV to Member Name as prefix.
  • The Match with option is set to Member Name or Alias.

setting the Match function parameters

When previewing the grid with Aug as the Year POV selection, note that the first column displays Aug, which is the current POV; the second column displays AugYTD, which is the match for the Current POV of Aug and YTD.


Report Displays