DeepSee MDX Reference
- About This Book
- Basic Rules
- Expression Types
- Numeric Expressions
- String Expressions
- Logical Expressions
- Tuple Expressions
- Member Expressions
- Level Expressions
- Hierarchy Expressions
- Set Expressions
- Measure Search Expressions
- Quality Measure Expressions
- MDX Statements and Clauses
- %FILTER Clause
- CREATE MEMBER Statement
- CREATE SET Statement
- DRILLFACTS Statement
- DRILLTHROUGH Statement
- DROP MEMBER Statement
- DROP SET Statement
- FORMAT_STRING Clause
- SELECT Statement
- SET Statement
- SOLVE_ORDER Clause
- WHERE Clause
- WITH Clause
- MDX Functions
- %ALL
- %CELL
- %CELLZERO
- %FIRST
- %KPI
- %LABEL
- %LAST
- %LIST
- %LOOKUP
- %MDX
- %NOT
- %OR
- %SEARCH
- %SPACE
- %TERMLIST
- %TIMERANGE
- %TIMEWINDOW
- %TOPMEMBERS
- AGGREGATE
- ALLMEMBERS
- ANCESTOR
- AVG
- BOTTOMCOUNT
- BOTTOMPERCENT
- BOTTOMSUM
- CHILDREN
- CLOSINGPERIOD
- COUNT
- COUSIN
- CROSSJOIN
- CURRENTMEMBER
- DESCENDANTS
- DISTINCT
- EXCEPT
- FILTER
- FIRSTCHILD
- FIRSTSIBLING
- HEAD
- HIERARCHISE
- HIERARCHIZE
- IIF
- INTERSECT
- ISNULL
- LAG
- LASTCHILD
- LASTSIBLING
- LEAD
- LOG
- LOOKUP
- MAX
- MEDIAN
- MEMBERS
- MIN
- NEXTMEMBER
- NONEMPTYCROSSJOIN
- OPENINGPERIOD
- ORDER
- PARALLELPERIOD
- PARENT
- PERCENTILE
- PERCENTILERANK
- PERIODSTODATE
- POWER
- PREVMEMBER
- PROPERTIES
- RANK
- ROUND
- SIBLINGS
- SQRT
- STDDEV
- STDDEVP
- STDEV
- STDEVP
- SUBSET
- SUM
- TAIL
- TOPCOUNT
- TOPPERCENT
- TOPSUM
- UNION
- VAR
- VARIANCE
- VARIANCEP
- VARP
- VISUALTOTALS
- Intrinsic Properties
- NOW Member for Time Levels
- Quick Function Reference