MDX Functions Reference
This section describes the standard MDX functions. Each function is illustrated with several working examples. You may refer to this page to get the list of icCube specific MDX functions.
Group : Color
Group : Logical
- CoalesceEmpty
- CoalesceNull (6.0)
- Iif
- IsAll
- IsAncestor
- IsDefault
- IsEmpty
- IsGeneration
- IsLeaf
- IsSibling
- IsUnknown (5.0)
Group : Member
- Ancestor
- ClosingPeriod
- ContextMember (6.5.1)
- ContextMembers (6.5.1)
- Cousin
- Current
- CurrentMember
- DefaultMember
- FirstChild
- FirstSibling
- GetProperty (6.8.3)
- IsDayLevel (6.6)
- IsHalfYearLevel (6.6)
- IsMonthLevel (6.6)
- IsQuarterLevel (6.6)
- IsWeekLevel (6.6)
- IsYearLevel (6.6)
- Lag
- LastChild
- LastSibling
- Lead
- LinkMember
- LookupByKey
- LookupByName (7.3)
- MemberValue
- NameToSet
- NextMember
- OpeningPeriod
- ParallelPeriod
- Parent
- PrevMember
- Properties
- SetProperty (6.8.3)
Group : Monitoring
Group : Numeric
- AddN (4.7)
- Aggregate
- Avg
- Correlation
- Count
- Count(Dimensions)
- Count(Level)
- Count(Levels)
- Covariance
- CovarianceN
- CurrentCellValue
- Distinct
- DistinctCount
- Divide
- DivN (4.7)
- ElementValue (4.8)
- Eval (5.1.1)
- LinRegIntercept
- LinRegPoint
- LinRegR2
- LinRegSlope
- Matrix
- MatrixA (4.8)
- MatrixN (5.1.3)
- Max
- Median
- Min
- MinusN (4.7)
- Percentile (6.1)
- PercN (4.7)
- Prod (6.0)
- SetAxes (4.8)
- Stddev
- StddevP
- Stdev
- StdevP
- Sum
- SumOn (6.0.3)
- Value
- Var
- Variance
- VarianceP
- VarP
- Vector
- VectorA (4.8)
- VectorK (6.0.3)
- VectorN (5.1.3)
- WAvg
Group : Other
- Dimension
- Dimensions
- Error
- FirstNotAllLevel
- GetPropertyUniqueValues (8.0.0.rc-4)
- Hierarchy
- IsError
- LastLevel
- Level
- Levels
- Name
- Ordinal
- SubCubeComplement (4.7)
- SubCubeIntersect (4.7)
- SubCubeMinus (4.7)
- SubCubeOthers (5.0)
- SubCubeSymDifference (4.7)
- SubCubeUnion (4.7)
- UniqueName
Group : Set
- AddCalculatedMembers
- AllMembers
- Ancestors
- Ascendants
- Axis
- BottomCount
- BottomPercent
- BottomSum
- Children
- CompactSet
- Crossjoin
- CurrentOrdinal
- Descendants
- DrilldownLevel
- DrilldownLevelBottom
- DrilldownLevelTop
- DrilldownMember
- DrilldownMemberBottom
- DrilldownMemberTop
- DrillUpLevel
- DrillUpMember
- Except
- Exists
- Extract
- ExtractOthers (4.7)
- Filter
- Generate
- GetFilterInfo (5.1.1)
- Head
- Hierarchize
- IndexOf
- Intersect
- IsIn
- Item
- LastPeriods
- MeasureGroupMeasures
- Members
- Mtd
- NonEmpty
- NonEmptyX (6.8.3)
- Order
- PeriodsToDate
- Qtd
- Range (6.8.6)
- Rank
- RemoveUnknown (5.0)
- Replicate (6.0)
- Reverse (5.0)
- Siblings
- Slicer (5.1.1)
- StripCalculatedMembers
- SubSelectAxis (5.1.1)
- Subset
- Tail
- TopCount
- TopPercent
- TopSum
- Union
- Unorder
- UpperCrossjoin (5.0)
- VisualTotals
- Wtd
- Ytd
Group : String
- MemberToStr
- PatternMatches
- PatternMatchesContains (8.0.0-rc.3)
- PatternMatchesEndsWith (8.0.0-rc.3)
- PatternMatchesEquals (8.0.0-rc.3)
- PatternMatchesStartsWith (8.0.0-rc.3)
- SetToStr
- StrToHierarchy
- StrToLevel
- StrToMember
- StrToSet
- StrToTuple
- StrToValue
- TupleToStr
Group : Time Intelligence
- dtAsOf (6.7.5)
- dtAsOfToday (6.7.5)
- dtAsOfYesterday (6.7.5)
- dtDatesItd (7.6)
- dtDatesMfd (6.0)
- dtDatesMtd (6.0)
- dtDatesQfd (6.0)
- dtDatesQtd (6.0)
- dtDatesWeek (6.0)
- dtDatesWeekend (6.0)
- dtDatesWfd (6.0)
- dtDatesWtd (6.0)
- dtDatesYfd (6.0)
- dtDatesYtd (6.0)
- dtFirstDayOfWeekOfMonth (6.0)
- dtFirstDayOfWeekOfQuarter (6.0)
- dtFirstDayOfWeekOfYear (6.0)
- dtGetDayOfMonth (6.2)
- dtGetDayOfWeek (6.2)
- dtGetDayOfYear (6.2)
- dtGetMonthOfYear (6.2)
- dtGetWeekOfYear (6.2)
- dtGetYear (6.2)
- dtLastDayOfWeekOfMonth (6.0)
- dtLastDayOfWeekOfQuarter (6.0)
- dtLastDayOfWeekOfYear (6.0)
- dtMinusDays (6.0)
- dtMinusMonths (6.0)
- dtMinusQuarters (6.0)
- dtMinusWeeks (6.0)
- dtMinusYears (6.0)
- dtNextDay (6.0)
- dtNextMonth (6.0)
- dtNextQuarter (6.0)
- dtNextWeek (6.0)
- dtNextYear (6.0)
- dtNthDayOfWeekOfMonth (6.0)
- dtNthDayOfWeekOfQuarter (6.0)
- dtNthDayOfWeekOfYear (6.0)
- dtPlusDays (6.0)
- dtPlusMonths (6.0)
- dtPlusQuarters (6.0)
- dtPlusWeeks (6.0)
- dtPlusYears (6.0)
- dtPreviousDay (6.0)
- dtPreviousMonth (6.0)
- dtPreviousQuarter (6.0)
- dtPreviousWeek (6.0)
- dtPreviousYear (6.0)
- dtRollingMonths (6.6)
- dtWithDayOfMonth (6.0)
- dtWithDayOfWeek (6.0)
- dtWithDayOfYear (6.0)
- dtWithMonthOfYear (6.0)
- dtWithTime (6.0)
- dtWithYear (6.0)
Group : Tuple
Group : Utility