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.
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.
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 theNoteCreatedOn
function has ashort
date parameter, which means for a US locale, the format isMM/DD/YY
. The time parameter isnone
, which means the time will not be displayed. -
For the
NotePOVDimension
andNotePOVMemberLabel
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.
You can see a portion of the text box output with the corresponding text functions in the Note Format: