MDX Functions Reference
This section describes the standard MDX functions. Each function is illustrated with several working examples.
Group : color
Group : logical
Group : member
- Ancestor
- ClosingPeriod
- Cousin
- CurrentMember
- DefaultMember
- FirstChild
- FirstSibling
- Lag
- LastChild
- LastSibling
- Lead
- LinkMember
- LookupByKey
- NameToSet
- NextMember
- OpeningPeriod
- ParallelPeriod
- Parent
- PrevMember
- Properties
Group : numeric
- Aggregate
- Avg
- Count
- Count(Dimensions)
- Count(Level)
- Count(Levels)
- CurrentCellValue
- Distinct
- DistinctCount
- Max
- Median
- Min
- Sum
- Value
- Wavg
Group : other
Group : set
- AddCalculatedMembers
- AllMembers
- Ancestors
- Ascendants
- BottomCount
- BottomPercent
- BottomSum
- Children
- CompactSet
- Crossjoin
- Current
- CurrentOrdinal
- Descendants
- Except
- Exists
- Extract
- Filter
- Generate
- Head
- Hierarchize
- Iif
- Intersect
- LastPeriods
- MeasureGroupMeasures
- Members
- Mtd
- NonEmpty
- Order
- PeriodsToDate
- Qtd
- Rank
- Siblings
- StripCalculatedMembers
- Subset
- Tail
- TopCount
- TopPercent
- TopSum
- Union
- VisualTotals
- Ytd
Group : string
- MemberToStr
- SetToStr
- StrToHierarchy
- StrToLevel
- StrToMember
- StrToSet
- StrToTuple
- StrToValue
- TupleToStr
Group : tuple
Group : utility
icCube OLAP version: 2.5.1 13-May-2012 02:21:10 GMT