@ISCHILD
Whether the current member is a child of member.
@ISDESC
Whether the current member is a descendant of member.
@ISGEN
Whether the current member of dimension is in generation.
@ISLEV
Whether the current member of dimension is in level.
@ISMBR
Whether
the current member is member, or is found in member list,
or is found in a range returned by another function.
@ISSIBLIN Whether the current member is a sibling of member.
G
@GEN
Generation number of member.
@LEV
Level number of member.
@XREF
Values from a different database than the one being
calculated.
@TRUNCA Expression with fractional part removed, returning an
TE
integer.
@VAR
Variance between two members.
Member Set Functions:
Function
Return Value
@ALLANCESTO All ancestors of member, including ancestors of shared
RS
member.
@ANCEST
Ancestor at distance from the current member or an
explicitly specified member.
@ANCESTORS
All ancestors of member, or those up to a specified
distance.
@ATTRIBUTE
All base members associated with attribute member
name.
@CHILDREN
Children of member.
@CURRMBR
Member currently being calculated in the specified
dimension.
@DESCENDAN
All descendants of member, or those down to a
TS
specified distance.
@GENMBRS
Members of dimension that are at generation.
@IALLANCEST
ORS
Member and ancestors of member, including ancestors
of shared member.
@IANCESTORS
Member and all its ancestors, or those up to a specified
distance.
@ICHILDREN
Member and its children.
@IDESCENDAN Member and all its descendants, or those down to a
TS
specified distance.
@ILSIBLINGS
Member and its left siblings.
@IRSIBLINGS
Member and its right siblings.
@IRDESCENDA Member and all its descendants, or those down to a
NTS
specified distance, including descendants of shared
member.
@ISIBLINGS
Member and its siblings.
@LEVMBRS
Members of dimension that are at level.
@LIST
A single list compiled from arguments, and can be used
for functions requiring an expression list, a member list,
or a range list.
@LSIBLINGS
Left siblings of member.
@MATCH
Members that match a pattern search performed over a
generation, a level, or a member and its descendants.
@MEMBER
Member with name string.
@MERGE
Merged list from two lists.
@PARENT
Parent of the current member being calculated in
dimension, optionally crossed with another member.
@RANGE
Member list that crosses a member from one dimension
with a range from another dimension.
@RDESCENDA
NTS
All descendants of member, or those down to a
specified distance, including descendants of shared
member.
@RELATIVE
All members that are at distance from member.
@REMOVE
List1, with anything that is also in list2 removed.
@RSIBLINGS
Right siblings of member.
@SIBLINGS
Siblings of member.
@UDA
Members of dimension that have UDA.
@WITHATTR
Base members from dimension that are associated with
an attribute meeting a condition.
@XRANGE
Range of members between (and inclusive of) two
members at the same level.
@MDSHIF The next or nth member in a range of members, retaining all
T
other members identical to the current member across
multiple dimensions
@PRIOR
A list of the previous or nth previous members in a range of
members
@ALLOCA Allocates values to lower-level members in one level.
TE
The date function converts date strings to numbers that can be used in
calculation formulas.
@TODATE
The date function converts date strings to numbers that can be used in
calculation formulas.
:
