A.1. Index to Functions

We have found that two different types of indexes are useful for looking up a function or operator: by name and by return type.

A.1.1. Alphabetical Index

AddCalculatedMembers(): 703Ancestors(): 706
Aggregate(): 704And: 707
.AllMembers(): 705Ascendants(): 707
Ancestor(): 706Avg(): 708
Axis(): 708DrillDownMember(): 729
BottomCount(): 710DrillDownMemberBottom(): 731
BottomPercent(): 710DrillDownMemberTop(): 731
BottomSum(): 710DrillUpLevel(): 732
Calculate: 710DrillUpMember(): 732
CalculationCurrentPass(): 710Error(): 734
CalculationPassValue(): 711Except(): 735
Call: 711Existing: 735
CASE: 712Exists(): 736
.Children: 713Extract(): 736
ClosingPeriod(): 713Filter(): 736
CoalesceEmpty(): 713.FirstChild: 737
Correlation(): 714.FirstSibling: 737
Count(): 715Generate(): 738
.Count: 715Head(): 739
Cousin(): 716Hierarchize(): 739
Covariance(): 716.Hierarchy: 739
CovarianceN(): 716.Ignore: 740
Crossjoin(): 718Iif(): 740
.Current: 718Intersect(): 741
.CurrentMember: 718Is: 742
.CurrentOrdinal: 719IsAncestor(): 743
CustomData: 719IsEmpty(): 743
.DataMember: 719IsGeneration(): 743
.DefaultMember: 720IsLeaf(): 744
Descendants(): 720IsSibling(): 745
.Dimension: 724.Item(): 745
Dimensions(): 724KPICurrentTimeMember(): 746
Distinct(): 726KPIGoal(): 747
DistinctCount(): 726KPIStatus(): 747
DrillDownLevel(): 726KPITrend(): 747
DrillDownLevelBottom(): 727KPIValue(): 747
DrillDownLevelTop(): 728KPIWeight(): 747
.Lag(): 748.Parent: 766
.LastChild: 748PeriodsToDate(): 768
LastPeriods(): 748Predict(): 769
.LastSibling: ...

Get Professional SQL Server™ Analysis Services 2005 with MDX now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.