Create offline cube files (.cub) with OlapCube. Download Now!


Overview

  • Introduction to MDX
  • Key Concepts in MDX
  • Comparison of SQL and MDX

    Basic MDX

  • The Basic MDX Query
  • Members, Tuples, and Sets
  • Axis and Slicer Dimensions
  • Specifying the Contents of an Axis Dimension
  • Specifying the Contents of a Slicer Dimension
  • Establishing Cube Context

    Advanced MDX

  • Using Member Properties
  • Intrinsic Dimension and Level Member Properties
  • Intrinsic Member Properties
  • Custom Member Properties
  • Using Cell Properties
  • FORMAT_STRING Contents
  • FORE_COLOR and BACK_COLOR Contents
  • Building Named Sets in MDX
  • Building Calculated Members in MDX
  • Using WITH to Create Calculated Cells

    Effective MDX

  • Working with Empty Cells
  • Creating a Cell Within the Context of a Cube
  • Working with the RollupChildren Function
  • WHERE Clause Overrides

    MDX functions

    AddCalculatedMembers   Aggregate   AllMembers   Ancestor   Ancestors   Ascendants   Avg   Axis   BottomCount   BottomPercent   BottomSum   CalculationCurrentPass   CalculationPassValue   Call   Children   ClosingPeriod   CoalesceEmpty   Correlation   Count   Cousin   Covariance   CovarianceN   Crossjoin   Current   CurrentMember   DataMember   DefaultMember   Descendants   Dimension   Dimensions   Distinct   DistinctCount   DrilldownLevel   DrilldownLevelBottom   DrilldownLevelTop   DrilldownMember   DrilldownMemberBottom   DrilldownMemberTop   DrillupLevel   DrillupMember   Except   Extract   Filter   FirstChild   FirstSibling   Generate   Head   Hierarchize   Hierarchy   IIf   Intersect   Is   IsAncestor   IsEmpty   IsLeaf   IsSibling   Item   Lag   LastChild   LastPeriods   LastSibling   Lead   Level   Levels   LinkMember   LinRegIntercept   LinRegPoint   LinRegR2   LinRegSlope   LinRegVariance   Max   Median   Members   MemberToStr   Min   Mtd   Name   NameToSet   NextMember   NonEmptyCrossjoin   OpeningPeriod   Order   Ordinal   ParallelPeriod   Parent   PeriodsToDate   PrevMember   Properties   Qtd   Rank   RollupChildren   SetToArray   SetToStr   Siblings   Stdev   StdevP   StripCalculatedMembers   StrToMember   StrToSet   StrToTuple   StrToValue   Subset   Sum   Tail   ToggleDrillState   TopCount   TopPercent   TopSum   TupleToStr   Union   UniqueName   UserName   ValidMeasure   Value   Var   Variance   VarianceP   VarP   VisualTotals   Wtd   Ytd