MDX Functions


Functions can be used to generate metadata and/or value information that you need to pass to a SELECT statement. Becoming proficient with the functions reduces the need to enumerate tuples, members, numeric values, or other needed values explicitly in the set specifications of a query. More importantly, using functions allows in-depth analysis of your database.

Abs
Ancestor
Ancestors
Attribute
Avg
BottomCount
BottomPercent
BottomSum
Case
Children
ClosingPeriod
CoalesceEmpty
Count
Cousin
CrossJoin
CurrentMember
CurrentTuple
DefaultMember
Descendants
Distinct
Dimension
DrilldownByLayer
DrilldownMember
DrillupByLayer
DrillupMember
Except
Exp
Extract
Factorial
Filter
FirstChild
FirstSibling
Generate
Generation
Generations
Head
Hierarchize
IIF
Int
Intersect
Is
IsAccType
IsAncestor
IsChild
IsEmpty
IsGeneration
IsLeaf
IsLevel
IsSibling
IsUda
IsValid
Item
Lag
LastChild
LastPeriods
LastSibling
Lead
Level
Levels
Ln
Log
Log10
Max
MemberRange
Members
Min
Mod
NextMember
NonEmptyCount
OpeningPeriod
Order
Ordinal
ParallelPeriod
Parent
PeriodsToDate
Power
PrevMember
RelMemberRange
Remainder
Round
Siblings
Subset
Sum
Tail
ToDate
TopCount
TopPercent
TopSum
Truncate
Uda
Union
Value
WithAttr
xTD

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com