MDX标准函数列表

标准的MDX函数：

<Dimension>.Dimension
<Level>.Dimension
<Member>.Dimension
Dimensions(<Numeric Expression>)
Dimensions(<String Expression>)
<Hierarchy>.Levels(<Numeric Expression>)
<Hierarchy>.Levels(<String Expression>)
Levels(<String Expression>)
Cousin
<Member>.DataMember
<Dimension>.DefaultMember
<Hierarchy>.DefaultMember
<Member>.FirstChild
<Member>.FirstSibling
<Member>.LastChild
<Member>.LastSibling
Members(<String Expression>)
<Member>.NextMember
<Member>.Parent
<Member>.PrevMember
StrToMember(<String Expression>)
<Set>.Count
InStr(<String Expression>, <String Expression>)
<Level>.Ordinal
<Measure>.Value
Ascendants(<Member>)
<Member>.Children
DrilldownMemberBottom(<Set1>, <Set2>, <Count>[, [<Numeric Expression>][, RECURSIVE]])
DrilldownMemberTop(<Set1>, <Set2>, <Count>[, [<Numeric Expression>][, RECURSIVE]])
DrillupLevel(<Set>[, <Level>])
DrillupMember(<Set1>, <Set2>)
<Dimension>.Members
<Dimension>.AllMembers
<Hierarchy>.Members
<Hierarchy>.AllMembers
<Level>.Members
<Level>.AllMembers
StripCalculatedMembers(<Set>)
<Member>.Siblings
<Dimension>.Caption
<Hierarchy>.Caption
<Level>.Caption
<Member>.Caption
<Dimension>.Name
<Hierarchy>.Name
<Level>.Name
<Member>.Name
<Dimension>.UniqueName
<Hierarchy>.UniqueName
<Level>.UniqueName
<Member>.UniqueName
<Set>.Current
<Numeric Expression> + <Numeric Expression>
<Numeric Expression> - <Numeric Expression>
<Numeric Expression> * <Numeric Expression>
<Numeric Expression> / <Numeric Expression>
- <Numeric Expression>
<String Expression> || <String Expression>
<Logical Expression> AND <Logical Expression>
<Logical Expression> OR <Logical Expression>
NOT <Logical Expression>
<String Expression> = <String Expression>
<Numeric Expression> = <Numeric Expression>
<String Expression> <> <String Expression>
 <Numeric Expression> <> <Numeric Expression>
 <Numeric Expression> < <Numeric Expression>
 <String Expression> < <String Expression>
 <Numeric Expression> <= <Numeric Expression>
 <String Expression> <= <String Expression>
 <Numeric Expression> > <Numeric Expression>
 UCase(<String Expression>)
 Len(<String Expression>)
 FirstQ(<Set>[, <Numeric Expression>])
 ThirdQ(<Set>[, <Numeric Expression>])
 Parameter(<Name>, <Type>, <DefaultValue>, <Description>)
 ParamRef(<Name>)
 Case <Expression> When <Expression> Then <Expression> [...] [Else <Expression>] End
 (<Member> [, <Member>]...)
 StrToTuple
 <Set>.Item(<String> [, ...])
 <Set>.Item(<Index>)
 TupleToStr
 SetToStr
 Ytd([<Member>])
 Wtd([<Member>])
 VisualTotals(<Set>[, <Pattern>])
 Union(<Set1>, <Set2>[, ALL])
 ToggleDrillState(<Set1>, <Set2>[, RECURSIVE])
 Tail(<Set>[, <Count>])
 Subset(<Set>, <Start>[, <Count>])
 <Set> StrToSet(<String>[, <Dimension>...])
 Qtd([<Member>])
 PeriodsToDate([<Level>[, <Member>]])
 Order(<Set>, <Value Expression>[, ASC | DESC | BASC | BDESC])
 Mtd([<Member>])
 LastPeriods(<Index> [, <Member>])
 Intersect(<Set1>, <Set2>[, ALL])
 Hierarchize(<Set>[, POST])
 Head(<Set>[, < Numeric Expression >])
 Generate(<Set>, <String>[, <String>])
 Generate(<Set1>, <Set2>[, ALL])
 Filter
Extract(<Set>, <Dimension>[, <Dimension>...])
Except(<Set1>, <Set2>[, ALL])
DrilldownMember(<Set1>, <Set2>[, RECURSIVE])
Distinct
Descendants(<Member>[, <Level>[, <Desc_flag>]])
Crossjoin(<Set1>, <Set2>)
NonEmptyCrossJoin(<Set1>, <Set2>)
Crossjoin(<Set1>, <Set2>)
TopSum(<Set>, <Value>, <Numeric Expression>)
TopPercent(<Set>, <Percentage>, <Numeric Expression>)
TopCount(<Set>, <Count>[, <Numeric Expression>])
TopCount(<Set>, <Count>[, <Numeric Expression>])
BottomSum(<Set>, <Value>, <Numeric Expression>)
BottomPercent(<Set>, <Percentage>, <Numeric Expression>)
BottomCount(<Set>, <Count>[, <Numeric Expression>])
AddCalculatedMembers
VarP(<Set>[, <Numeric Expression>])
VarianceP(<Set>[, <Numeric Expression>])
Variance(<Set>[, <Numeric Expression>])
Var(<Set>[, <Numeric Expression>])
Sum(<Set>[, <Numeric Expression>])
StddevP(<Set>[, <Numeric Expression>])
StdevP(<Set>[, <Numeric Expression>])
Stddev(<Set>[, <Numeric Expression>])
Stdev(<Set>[, <Numeric Expression>])
Rank(<Tuple>, <Set> [, <Calc Expression>])
Percentile(<Set>, <Numeric Expression>, <Percent>)
Median(<Set>[, <Numeric Expression>])
Min(<Set>[, <Numeric Expression>])
Max(<Set>[, <Numeric Expression>])
LinRegVariance(<Set>, <Numeric Expression>[, <Numeric Expression>])
LinRegSlope(<Set>, <Numeric Expression>[, <Numeric Expression>])
LinRegR2(<Set>, <Numeric Expression>[, <Numeric Expression>])
LinRegPoint(<Numeric Expression>, <Set>, <Numeric Expression>[, <Numeric Expression>])
LinRegIntercept(<Set>, <Numeric Expression>[, <Numeric Expression>])
IIf
CovarianceN(<Set>, <Numeric Expression>[, <Numeric Expression>])
Covariance(<Set>, <Numeric Expression>[, <Numeric Expression>])
Count(<Set>[, EXCLUDEEMPTY | INCLUDEEMPTY])
Correlation(<Set>, <Numeric Expression>[, <Numeric Expression>])
Avg(<Set>[, <Numeric Expression>])
Aggregate(<Set>[, <Numeric Expression>])
ValidMeasure
ParallelPeriod([<Level>[, <Numeric Expression>[, <Member>]]])
ClosingPeriod([<Level>[, <Member>]])
OpeningPeriod([<Level>[, <Member>]])
<Member>.Lead(<Numeric Expression>)
<Member>.Lag(<Numeric Expression>)
CurrentMember
CurrentMember
<Expression> IS <Expression>
<Expression> IS NULL
<Value Expression> IS EMPTY
IsEmpty(<Value Expression>)

 

 

统计不全

 slob