Home
MDX functions
MDX functions
This section describes the MDX functions.
Side TOC
Side TOC
MDX functions
Abs
AddCalculatedMembers
Aggregate
AllMembers
Ancestor
Ascendants
Avg
BottomCount
BottomPercent
BottomSum
Children
ClosingPeriod
Count
Cousin
Crossjoin
CStr
CurrentMember
DefaultMember
Descendants
Dimension
Dimensions
Distinct
DistinctNative
DrillDownInSet
DrilldownLevel
DrilldownMember
DrillupMember
Element_Type
Except
ExpandLevels
Filter
FilterEQ
FilterGE
FilterGT
FilterHS
FilterLE
FilterLT
FilterNE
FilterNS
FilterZS
FirstChild
Generate
HasNote
Head
Hierarchize
Hierarchy
IIf
InStr
Intersect
IS
IsAncestor
IsEmpty
IsGeneration
IsLeaf
IsSibling
Item
Lag
LastChild
LastPeriods
Lead
Left
Level
Levels
LinRegIntercept
LinRegPoint
LinRegSlope
Max
Median
Members
Mid
Min
Mode
Mtd
Name
Nest
NextMember
OpeningPeriod
Order
Ordinal
ParallelPeriod
Parent
PeriodsToDate
PrevMember
Properties
Qtd
Rank
RegExp
Right
Rnd
RollUpInSet
RootMembers
Siblings
Solve_Order
SplashValue
Standardize
Stddev (Alias: Stdev)
StddevP (Alias: StdevP)
StripCalculatedMembers
StrToMember
StrToSet
StrToValue
Subset
Sum
Tail
ToggleDrillState
TopCount
TopPercent
TopSum
Union
UnionSort
UniqueName
UserName
Val
Variance (Alias: Var)
VarianceP (Alias: VarP)
Wildcard
WriteComment
WriteProperty
WriteValue
Wtd
Ytd