Formulas

Alea formulas fall into the categories described in this topic.

See the Infor BI Office Plus for Microsoft Office Excel online help for information on the formulas.

• Attributes formulas
• Cell notes formulas
• Cube properties formulas
• Dimension properties formulas
• Element properties formulas
• Element selection formulas
• Special formulas
• Subset properties formulas
• Values formulas
• Writeback formulas

Attributes formulas

• AT.COUNT
• AT.FIELD
• AT.FIELDCOUNT
• AT.FIELDINDEX
• AT.FIELDTYPE
• AT.GET
• AT.HEAD
• AT.NAME
• AT.SET
• AT.SUB.HEAD

Cell notes formulas

• DIM.MASK.NOTE.DELETE
• DIM.MASK.NOTE.GET
• DIM.MASK.NOTE.SET
• NGET
• NSET

Cube properties formulas

• STABLE.COUNT
• STABLE.NAME
• TABLE.GET.INFO
• TDIM.COUNT
• TDIM.NAME

Dimension properties formulas

• AT.COUNT
• DE.COUNT
• DE.FIRST
• DE.NEXT
• DIM.TOPLEVEL
• DIMENSION.GET.INFO

Element properties formulas

• DE.CHILDNAME
• DE.CHILDRENCOUNT
• DE.COUNT
• DE.FIRST
• DE.INDEX
• DE.ISCHILD
• DE.LEVEL
• DE.NEXT
• DE.PARENTNAME
• DE.PARENTSCOUNT
• DE.PREV
• DE.SIBLING
• DE.TOPCOUNT
• DE.TOPNAME
• DE.TYPE
• DE.WEIGHT

Element selection formulas

• DE.ADD
• DE.NAME
• SE.NAME

Special formulas

• MDS.ERROR
• MDS.ISNA
• MDS.LAST.ERROR
• MDS.NA
• MDS.SET.LAST.ERROR
• SERVER.GET.INFO
• VALUE.BUFFER.ANYTHING.CHANGED
• VALUE.BUFFER.GET.CALC.STATE
• WORKSPACE.GET.PARAMETER
• WORKSPACE.MAKE
• WORKSPACE.RELEASE
• WORKSPACE.SUBRELEASE
• WORKSPACE.VERSION

Subset properties formulas

• SE.COUNT
• SE.INDEX

Values formulas

• DBGET
• DBGETC
• DBGETC.FIRST
• DBGETC.NEXT

Writeback formulas

• DBGET
• DBGETC
• DBSET
• DBSET2
• DBSET3