Show TOC

Syntax for Entering ValuesLocate this document in the navigation structure

Follow these syntax rules when you enter members for filtering and values for prompting.

For compounded dimensions, the complete compounded key of the member must be used.

Description Example
Equal to 15
Exclude value !22
Value range 1-5
Exclude value range !6-9
Greater than >8
Exclude values greater than <value limit> !>8
Greater than or equal to >=8
Exclude values greater than or equal to <value limit> !>=8
Less than <12
Exclude values less than <value limit> !<12
Less than or equal to <=12
Exclude values less than or equal to <value limit> !<=12
Contains pattern (for example, all values that begin with A)* A*
Exclude values that contain pattern (for example, exclude all values that begin with A)* !A*
Dimension hierarchy node +<Dimension Attribute>(<Technical Name of Dimension>)

For example: +ELEMENT1(WBS_ELEMENT)

Text hierarchy node +<Technical Name of Hierarchy Node>(0HIER_NODE)

For example: +EUROPE(0HIER_NODE)

Delimiter for multiple values; semicolon followed by a space 1-5; >12; !8
Multiple values may also be passed as an array of strings

1-5

>12

!8
Escape character; backslash without space \

If you enter a string that contains one of the special characters used in these syntax rules, you can use a backslash as escape character.

For example: Enter the string CA-QU as CA\-QU.

*You cannot use these syntax rules for filtering.