.png)
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 |
|
