Types of MDX Functions available in MDX Queries.

Different type of Category as below

1.       MDX KPI Functions

2.       MDX Metadata Functions

3.       MDX Navigation Functions

4.       MDX Other Functions

5.       MDX Set Functions

6.       MDX Statistical Functions

7.       MDX String Functions

8.       MDX SubCube Functions

9.       MDX Time Functions

10.   MDX UI Functions

11.   MDX Value Functions

1-MDX KPI Functions

             KPICurrentTimeMember 

             KPIGoal 

             KPIStatus 

             KPITrend 

             KPIValue 

             KPIWeight 

2-MDX Metadata Functions

             Axis 

             Count (Dimension) 

             Count (Hierarchy Levels) 

             Count (Tuple) 

             Hierarchy 

             Level 

             Levels 

             Name 

             Ordinal 

             UniqueName 

3-MDX Navigation Functions

             Ancestor 

             Ancestors 

             Ascendants 

             Children 

             Cousin 

             Current 

             CurrentMember 

             CurrentOrdinal 

             DataMember 

             DefaultMember 

             FirstChild 

             FirstSibling 

             IsAncestor 

             IsGeneration 

             IsLeaf 

             IsSibling 

             Lag 

             LastChild 

             LastSibling 

             Lead 

             LinkMember 

             LookupCube 

             NextMember 

             Parent 

             PrevMember 

             Properties 

             Siblings 

             UnknownMember

4-MDX Other Functions

             CalculationCurrentPass 

             CalculationPassValue 

             CustomData 

             Dimension 

             Dimensions 

             Error 

             Item (Member) 

             Item (Set) 

             Members (String) 

             Predict 

             SetToArray 

5-MDX Set Functions

             AddCalculatedMembers 

             AllMembers 

             BottomCount 

             BottomPercent 

             BottomSum 

             Crossjoin 

             Descendants 

             Distinct 

             Except 

             Exists 

             Extract 

             Filter 

             Generate 

             Head 

             Hierarchize 

             Intersect 

             MeasureGroupMeasures 

             Members (Set) 

             NonEmpty 

             NonEmptyCrossjoin 

             Order 

             StripCalculatedMembers 

             Subset 

             Tail 

             TopCount 

             TopPercent 

             TopSum 

             Union 

             Unorder    

6-MDX Statistical Functions

             Aggregate 

             Avg 

             CoalesceEmpty 

             Correlation 

             Count (Set) 

             Covariance 

             CovarianceN 

             DistinctCount 

             LinRegIntercept 

             LinRegPoint 

             LinRegR2 

             LinRegSlope 

             LinRegVariance 

             Max 

             Median 

             Min 

             Rank 

             RollupChildren 

             Stdev 

             StdevP 

             Sum 

             Var 

             VarP 

             VisualTotals 

7-MDX String Functions

             MemberToStr 

             NameToSet 

             Root 

             SetToStr 

             StrToMember 

             StrToSet 

             StrToTuple 

             StrToValue 

             TupleToStr 

             UserName 

8-MDX SubCube Functions

             Leaves 

             This 

9-MDX Time Functions

             ClosingPeriod 

             LastPeriods 

             Mtd 

             OpeningPeriod 

             ParallelPeriod 

             PeriodsToDate 

             Qtd 

             Wtd 

             Ytd 

            

10-MDX UI Functions

             DrilldownLevel 

             DrilldownLevelBottom 

             DrilldownLevelTop 

             DrilldownMember 

             DrilldownMemberBottom 

             DrilldownMemberTop 

             DrillupLevel 

             DrillupMember 

             ToggleDrillState 

            

11-MDX Value Functions

             IIf 

             IsEmpty 

             MemberValue 

             ValidMeasure 

             Value 

 

Posted by - SUHAS R. KUDEKAR (MCTS - Microsoft Business Intelligence)

Learning Office 2010 + SharePoint 2010 + SQL Server 2008 R2