MDX Reserved Words
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
Concepts
Reserved Keywords (MDX Syntax)
MDX Language Reference (MDX)