1. Designing with Reports for Oracle Enterprise Performance Management Cloud
  2. Working with Notes
  3. Using the Notes Text Function
  4. Working with Note Formats
  5. Understanding the Note Format Text Functions

Understanding the Note Format Text Functions

In this topic, you’ll understand the usage and corresponding results of some of the Note Format text functions.

There are two Note templates, "Performance Summary" and "Variance Summary", each with three Notes (one for each of the three Segments).

Example 11-3 Named POV Definition

The following Named POV was created in a report containing the Notes text function. Note that the two dimensions listed are Segments and Fiscal Calendar. Both dimensions contain member selections to filter which text functions are displayed. Since Segments is the first dimension listed, and Fiscal Calendar is the second dimension listed, the Ordinal parameter used in NotePOVDimension and NotePOVMemberLabel functions would be "1" for Segments and "2" for Fiscal Calendar, based on their order in the Named POV.


create a named pov and explaing the ordinal_parameter

Example 11-4 Note Format Definition

The Note Format contains the following Sections and text functions, each Section with different font formatting applied. The last two Sections are indented.


explaining each section

A few things to note about the text function parameters:

  • In the second Section, the Created by NoteAuthor() on NoteCreatedOn(short, none), if you see the NoteCreatedOn function has a short date parameter, which means for a US locale, the format is MM/DD/YY. The time parameter is none, which means the time will not be displayed.

  • For the NotePOVDimension and NotePOVMemberLabel functions in the fourth Section:

    • Note the Ordinal parameter for each set of functions. The first set has an Ordinal parameter of "1", which is the first dimension (Segments) in the Named POV. The second set has an Ordinal parameter of "2", which is the second dimension (Fiscal Calendar) in the Named POV.

    • The Delimiter parameters specified for both sets of functions will result in the following display: Dimension1: Member1, Dimension2: Member2

Example 11-5 Previewing a Report with the Note Text Box

Using the examples of the Named POV and Note Format displayed in the above section, you can preview the report that contains a text box with the Note text function.


previewing the report that contains a text box with the Note Text functions

You can see a portion of the text box output with the corresponding text functions in the Note Format:


explaining all the note text functions