Table of Contents
- Title and Copyright Information
- Accessibility and Support
- 1 Calculation and Query Reference Overview
-
2
Calculation Commands
- Calculation Commands Overview
- Calculation Operators
- Calculation Command Groups
-
Calculation Command List
- & (ampersand)
- AGG
- ARRAY
- CALC ALL
- CALC AVERAGE
- CALC DIM
- CALC FIRST
- CALC LAST
- CALC TWOPASS
- CCONV
- CLEARBLOCK
- CLEARCCTRACK
- CLEARDATA
- DATACOPY
- DATAEXPORT
- DATAEXPORTCOND
- DATAIMPORTBIN
- DATAMERGE
- ELSE
- ELSEIF
- ENDIF
- EXCLUDE…ENDEXCLUDE
- FIX…ENDFIX
- FIXPARALLEL...ENDFIXPARALLEL
- IF
- LOOP...ENDLOOP
- POSTFIXPARALLEL
- SET Commands
- SET AGGMISSG
- SET CACHE
- SET CALCDIAGNOSTICS
- SET CALCPARALLEL
- SET CALCTASKDIMS
- SET CCTRACKCALC
- SET CLEARUPDATESTATUS
- SET COPYMISSINGBLOCK
- SET CREATENONMISSINGBLK
- SET CREATEBLOCKONEQ
- SET DATAEXPORTOPTIONS
- SET DATAIMPORTIGNORETIMESTAMP
- SET EMPTYMEMBERSETS
- SET FRMLBOTTOMUP
- SET FRMLRTDYNAMIC
- SET HYBRIDBSOINCALCSCRIPT
- SET MSG
- SET NOTICE
- SET REMOTECALC
- SET RUNTIMESUBVARS
- SET SCAPERSPECTIVE
- SET TRACE
- SET TRACEID
- SET UPDATECALC
- SET UPTOLOCAL
- THREADVAR
- USE_MDX_INSERT
- VAR
-
3
Calculation Functions
- Calculation and Member Hierarchy
- Function Parameters
- Calculation Operators
- Operation Results on #MISSING and Zero Values
- Calculation Function Categories
-
Calculation Function List
- @ABS
- @ACCUM
- @ALLANCESTORS
- @ALIAS
- @ALLOCATE
- @ANCEST
- @ANCESTORS
- @ANCESTVAL
- @ATTRIBUTE
- @ATTRIBUTEBVAL
- @ATTRIBUTESVAL
- @ATTRIBUTEVAL
- @AVG
- @AVGRANGE
- @BETWEEN
- @CALCMODE
- @CHILDREN
- @COMPOUND
- @COMPOUNDGROWTH
- @CONCATENATE
- @CORRELATION
- @COUNT
- @CREATEBLOCK
- @CURGEN
- @CURLEV
- @CURRMBR
- @CURRMBRRANGE
- @DATEDIFF
- @DATEPART
- @DATEROLL
- @DECLINE
- @DESCENDANTS
- @DISCOUNT
- @ENUMVALUE
- @EQUAL
- @EXP
- @EXPAND
- @FACTORIAL
- @FORMATDATE
- @GEN
- @GENMBRS
- @GRIDTUPLES
- @GROWTH
- @IALLANCESTORS
- @IANCESTORS
- @ICHILDREN
- @IDESCENDANTS
- @ILANCESTORS
- @ILDESCENDANTS
- @ILSIBLINGS
- @INT
- @INTEREST
- @INTERSECT
- @IRDESCENDANTS
- @IRR
- @IRREX
- @IRSIBLINGS
- @ISACCTYPE
- @ISANCEST
- @ISATTRIBUTE
- @ISCHILD
- @ISDESC
- @ISGEN
- @ISIANCEST
- @ISIBLINGS
- @ISICHILD
- @ISIDESC
- @ISIPARENT
- @ISISIBLING
- @ISLEV
- @ISMBR
- @ISMBRUDA
- @ISMBRWITHATTR
- @ISPARENT
- @ISRANGENONEMPTY
- @ISSAMEGEN
- @ISSAMELEV
- @ISSIBLING
- @ISUDA
- @LANCESTORS
- @LDESCENDANTS
- @LEV
- @LEVMBRS
- @LIKE
- @LIST
- @LN
- @LOG
- @LOG10
- @LSIBLINGS
- @MATCH
- @MAX
- @MAXRANGE
- @MAXS
- @MAXSRANGE
- @MBRCOMPARE
- @MBRPARENT
- @MDALLOCATE
- @MDANCESTVAL
- @MDPARENTVAL
- @MDSHIFT
- @MEDIAN
- @MEMBER
- @MEMBERAT
- @MERGE
- @MIN
- @MINRANGE
- @MINS
- @MINSRANGE
- @MOD
- @MODE
- @MOVAVG
- @MOVMAX
- @MOVMED
- @MOVMIN
- @MOVSUM
- @MOVSUMX
- @NAME
- @NEXT
- @NEXTS
- @NEXTSIBLING
- @NONEMPTYTUPLE
- @NOTEQUAL
- @NPV
- @PARENT
- @PARENTVAL
- @POWER
- @PREVSIBLING
- @PRIOR
- @PRIORS
- @PTD
- @QUERYBOTTOMUP
- @RANGE
- @RANGEFIRSTVAL
- @RANGELASTVAL
- @RANK
- @RDESCENDANTS
- @RELATIVE
- @RELXRANGE
- @REMAINDER
- @REMOVE
- @RETURN
- @ROUND
- @RSIBLINGS
- @SANCESTVAL
- @SHARE
- @SHIFT
- @SHIFTMINUS
- @SHIFTPLUS
- @SHIFTSIBLING
- @SIBLINGS
- @SLN
- @SPARENTVAL
- @SPLINE
- @STDEV
- @STDEVP
- @STDEVRANGE
- @SUBSTRING
- @SUM
- @SUMRANGE
- @SYD
- @TODATE
- @TODATEEX
- @TODAY
- @TREND
- @TRUNCATE
- @UDA
- @VAR
- @VARPER
- @VARIANCE
- @VARIANCEP
- @WEIGHTEDSUMX
- @WITHATTR
- @XRANGE
- @XREF
- @XWRITE
- Custom-Defined Calculation Functions
- Custom-Defined Macros
- Functions Supported in Hybrid Mode
-
4
MDX
- Overview of MDX
- MDX Query Format
-
MDX Syntax and Specification
- Understanding BNF Notation
- MDX Grammar Rules
- MDX Syntax for Specifying Duplicate Member Names and Aliases
- MDX Axis Specifications
- MDX Slicer Specification
- MDX Cube Specification
- MDX Set Specification
- MDX With Section
- MDX Dimension Specification
- MDX Layer Specification
- MDX Member Specification
- MDX Hierarchy Specification
- MDX Tuple Specification
- MDX Create Set / Delete Set
- MDX Sub Select
- MDX Insert Specification
- MDX Export Specification
- MDX Operators
- About MDX Properties
- MDX Comments
- MDX Query Limits
- Aggregate Storage and MDX Outline Formulas
-
MDX Function Return Values
- MDX Functions that Return a Member
- MDX Functions that Return a Set
- MDX Functions that Return a Tuple
- MDX Functions that Return a Number
- MDX Function that Returns a Dimension
- MDX Functions that Return a Layer
- MDX Functions that Return a Boolean
- MDX Functions that Return a Date
- MDX Functions that Return a String
-
MDX Function List
- Abs
- Aggregate
- Ancestor
- Ancestors
- Attribute
- AttributeEx
- Avg
- BottomCount
- BottomPercent
- BottomSum
- Case
- CellValue
- Children
- ClosingPeriod
- CoalesceEmpty
- Concat
- Contains
- Count
- Cousin
- CrossJoin
- CrossJoinAttribute
- CurrentAxisMember
- CurrentMember
- CurrentTuple
- DateDiff
- DatePart
- DateRoll
- DateToMember
- DefaultMember
- Descendants
- Distinct
- Dimension
- DrilldownByLayer
- DrilldownMember
- DrillupByLayer
- DrillupMember
- DTS
- EnumText
- EnumValue
- Except
- Exp
- Extract
- Factorial
- Filter
- FirstChild
- FirstSibling
- FormatDate
- Generate
- Generation
- Generations
- GetFirstDate
- GetFirstDay
- GetLastDate
- GetLastDay
- GetNextDay
- GetRoundDate
- Head
- Hierarchize
- IIF
- InStr
- InString
- Int
- Intersect
- Is
- IsAccType
- IsAncestor
- IsChild
- IsEmpty
- IsGeneration
- IsLeaf
- IsLevel
- IsMatch
- IsSibling
- IsUda
- IsValid
- Item
- JulianDate
- Lag
- LastChild
- LastPeriods
- LastSibling
- Lead
- Leaves
- Left
- Len
- Level
- Levels
- LinkMember
- Ln
- Log
- Log10
- Lower
- LTrim
- Max
- Median
- MemberRange
- Members
- Min
- Mod
- NextMember
- NonEmptyCount
- NonEmptySubset
- NTile
- NumToStr
- OpeningPeriod
- Order
- Ordinal
- ParallelPeriod
- Parent
- Percentile
- PeriodsToDate
- Power
- PrevMember
- Rank
- RealValue
- RelMemberRange
- Remainder
- Right
- Round
- RTrim
- Siblings
- Stddev
- Stddevp
- StrToMbr
- StrToNum
- Subset
- Substring
- Sum
- Tail
- Todate
- TodateEx
- Today
- TopCount
- TopPercent
- TopSum
- Truncate
- TupleRange
- Uda
- Union
- UnixDate
- Upper
- Value
- WithAttr
- WithAttrEx
- xTD