In some functions, you may need to specify multiple members, or you may need to specify a range of members. For example, the @ISMBR function tests to see if a member that is currently being calculated matches any of a list or range of specified members.
Table 54 lists the syntax for specifying members:
Table 54. Syntax for Specifying Member Lists and Ranges
Member List or Range | Syntax |
---|---|
For example: Mar2001 | |
A comma-delimited (,) list of member names. For example: Mar2001, Apr2001, May2001 | |
A range of all members at the same level, between and including the two defining members | The two defining member names separated by a colon (:). For example: Jan2000:Dec2000 |
A range of all members in the same generation, between and including the two defining members | The two defining member names separated by two colons (::). For example: Q1_2000::Q4_2000 |
For a list of member list contents and corresponding functions, see Generating Member Lists. | |
Separate each range, list, and function with a comma (,). For example: Q1_97::Q4_98, FY99, FY2000 @SIBLINGS(Dept01), Dept65:Dept73, Total_Dept |
If you do not specify a list of members or a range of members in a function that requires either, Essbase uses the level 0 members of the dimension tagged as time. If no dimension is tagged as time, Essbase displays an error message.