MDX Reserved Words

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

The following table contains words reserved for use by Multidimensional Expressions (MDX). You should not use these words as part of any identifier, such as a cube name, or user-defined function name, in MDX.

ABSOLUTE DESC LEAVES SELF_BEFORE_AFTER
ACTIONPARAMETERSET DESCENDANTS LEVEL SESSION
ADDCALCULATEDMEMBERS DESCRIPTION LEVELS SET
AFTER DIMENSION LINKMEMBER SETTOARRAY
AGGREGATE DIMENSIONS LINREGINTERCEPT SETTOSTR
ALL DISTINCT LINREGPOINT SORT
ALLMEMBERS DISTINCTCOUNT LINREGR2 STDDEV
ANCESTOR DRILLDOWNLEVEL LINREGSLOPE STDDEVP
ANCESTORS DRILLDOWNLEVELBOTTOM LINREGVARIANCE STDEV
AND DRILLDOWNLEVELTOP LOOKUPCUBE STDEVP
AS DRILLDOWNMEMBER MAX STORAGE
ASC DRILLDOWNMEMBERBOTTOM MEASURE STRIPCALCULATEDMEMBERS
ASCENDANTS DRILLDOWNMEMBERTOP MEDIAN STRTOMEMBER
AVERAGE DRILLUPLEVEL MEMBER STRTOSET
AXIS DRILLUPMEMBER MEMBERS STRTOTUPLE
BASC DROP MEMBERTOSTR STRTOVAL
BDESC EMPTY MIN STRTOVALUE
BEFORE END MTD SUBSET
BEFORE_AND_AFTER ERROR NAME SUM
BOTTOMCOUNT EXCEPT NAMETOSET TAIL
BOTTOMPERCENT EXCLUDEEMPTY NEST THIS
BOTTOMSUM EXTRACT NEXTMEMBER TOGGLEDRILLSTATE
BY FALSE NO_ALLOCATION TOPCOUNT
CACHE FILTER NO_PROPERTIES TOPPERCENT
CALCULATE FIRSTCHILD NON TOPSUM
CALCULATION FIRSTSIBLING NONEMPTYCROSSJOIN TOTALS
CALCULATIONCURRENTPASS FOR NOT_RELATED_TO_FACTS TREE
CALCULATIONPASSVALUE FREEZE NULL TRUE
CALCULATIONS FROM ON TUPLETOSTR
CALL GENERATE OPENINGPERIOD TYPE
CELL GLOBAL OR UNION
CELLFORMULASETLIST GROUP PAGES UNIQUE
CHAPTERS GROUPING PARALLELPERIOD UNIQUENAME
CHILDREN HEAD PARENT UPDATE
CLEAR HIDDEN PASS USE
CLOSINGPERIOD HIERARCHIZE PERIODSTODATE USE_EQUAL_ALLOCATION
COALESCEEMPTY HIERARCHY POST USE_WEIGHTED_ALLOCATION
COLUMN IGNORE PREDICT USE_WEIGHTED_INCREMENT
COLUMNS IIF PREVMEMBER USERNAME
CORRELATION INCLUDEEMPTY PROPERTIES VALIDMEASURE
COUNT INDEX PROPERTY VALUE
COUSIN INTERSECT QTD VAR
COVARIANCE IS RANK VARIANCE
COVARIANCEN ISANCESTOR RECURSIVE VARIANCEP
CREATE ISEMPTY RELATIVE VARP
CREATEPROPERTYSET ISGENERATION ROLLUPCHILDREN VISUAL
CREATEVIRTUALDIMENSION ISLEAF ROOT VISUALTOTALS
CROSSJOIN ISSIBLING ROWS WHERE
CUBE ITEM SCOPE WITH
CURRENT LAG SECTIONS WTD
CURRENTCUBE LASTCHILD SELECT XOR
CURRENTMEMBER LASTPERIODS SELF YTD
DEFAULT_MEMBER LASTSIBLING SELF_AND_AFTER
DEFAULTMEMBER LEAD SELF_AND_BEFORE

See Also

Reserved Keywords (MDX Syntax)
MDX Language Reference (MDX)