Home      Functions     Common Solutions      Contact     






MDX Functions:
 
MDX Functions

 
Common Solutions

Common Solutions
 
Resource Links

MDX Books
MDX Related Software
MDX Related Blogs
 
Other Links

Contact Us
 

  MDX KPI Functions

KPICurrentTimeMember KPIGoal KPIStatus KPITrend
KPIValue KPIWeight



  MDX Metadata Functions

Axis Count (Dimension) Count (Hierarchy Levels) Count (Tuple)
Hierarchy Level Levels Name
Ordinal UniqueName



  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



  MDX Other Functions

CalculationCurrentPass CalculationPassValue CustomData Dimension
Dimensions Error Item (Member) Item (Set)
Members (String) Predict SetToArray



  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



  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



  MDX String Functions

MemberToStr NameToSet Root SetToStr
StrToMember StrToSet StrToTuple StrToValue
TupleToStr UserName



  MDX SubCube Functions

Leaves This



  MDX Time Functions

ClosingPeriod LastPeriods Mtd OpeningPeriod
ParallelPeriod PeriodsToDate Qtd Wtd
Ytd



  MDX UI Functions

DrilldownLevel DrilldownLevelBottom DrilldownLevelTop DrilldownMember
DrilldownMemberBottom DrilldownMemberTop DrillupLevel DrillupMember
ToggleDrillState



  MDX Value Functions

IIf IsEmpty MemberValue ValidMeasure
Value


 

 
Copyright 2008 by MDXpert.com.
 
Terms of Use                              Privacy Statement
 
Site Powered By - WinHost.Com