Predefined MDX.GET formulas

Predefined MDX.GET formulas fall into these categories:

• Cube properties formulas
• Element properties formulas
• Get element formulas
• Hierarchy properties formulas
• Level formulas
• User formulas

Cube properties formulas

• DIMENSIONS.COUNT

Element properties formulas

• ELEMENT.ATTRIBUTE
• ELEMENT.COUNT.CHILDREN
• ELEMENT.DIMENSION.NAME
• ELEMENT.HIERARCHY.NAME
• ELEMENT.ID
• ELEMENT.LEVEL.NAME
• ISGENERATION
• ISLEAF
• ISSIBLING

Get element formulas

• GET.CHILD
• GET.DEFAULTELEMENT
• GET.FIRSTSIBLING
• GET.LEAD
• GET.NEXT
• GET.PARENT
• GET.PREVIOUS

Hierarchy property formulas

• GET.DEFAULTELEMENT
• GET.HIERARCHY.PER.ID
• HIERARCHY.COUNT.ELEMENTS
• HIERARCHY.COUNT.LEVELS
• HIERARCHY.NAME

Level properties formulas

• LEVEL.COUNT.ELEMENT
• LEVEL.HIERARCHY.NAME
• LEVEL.NAME.PER.ID

User formulas

• USER.NAME