Specifying Member Lists and Ranges

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

One member

The member name.

For example:

Mar2001

A list of members

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

A function-generated list of members or a range of members

For a list of member list contents and corresponding functions, see Generating Member Lists.

A combination of ranges and list

Separate each range, list, and function with a comma (,).

For example:

Q1_97::Q4_98, FY99, FY2000

or

@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.