MDX Reserved Words

 

Updated: March 2, 2016

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.

ABSOLUTEDESCLEAVESSELF_BEFORE_AFTER
ACTIONPARAMETERSETDESCENDANTSLEVELSESSION
ADDCALCULATEDMEMBERSDESCRIPTIONLEVELSSET
AFTERDIMENSIONLINKMEMBERSETTOARRAY
AGGREGATEDIMENSIONSLINREGINTERCEPTSETTOSTR
ALLDISTINCTLINREGPOINTSORT
ALLMEMBERSDISTINCTCOUNTLINREGR2STDDEV
ANCESTORDRILLDOWNLEVELLINREGSLOPESTDDEVP
ANCESTORSDRILLDOWNLEVELBOTTOMLINREGVARIANCESTDEV
ANDDRILLDOWNLEVELTOPLOOKUPCUBESTDEVP
ASDRILLDOWNMEMBERMAXSTORAGE
ASCDRILLDOWNMEMBERBOTTOMMEASURESTRIPCALCULATEDMEMBERS
ASCENDANTSDRILLDOWNMEMBERTOPMEDIANSTRTOMEMBER
AVERAGEDRILLUPLEVELMEMBERSTRTOSET
AXISDRILLUPMEMBERMEMBERSSTRTOTUPLE
BASCDROPMEMBERTOSTRSTRTOVAL
BDESCEMPTYMINSTRTOVALUE
BEFOREENDMTDSUBSET
BEFORE_AND_AFTERERRORNAMESUM
BOTTOMCOUNTEXCEPTNAMETOSETTAIL
BOTTOMPERCENTEXCLUDEEMPTYNESTTHIS
BOTTOMSUMEXTRACTNEXTMEMBERTOGGLEDRILLSTATE
BYFALSENO_ALLOCATIONTOPCOUNT
CACHEFILTERNO_PROPERTIESTOPPERCENT
CALCULATEFIRSTCHILDNONTOPSUM
CALCULATIONFIRSTSIBLINGNONEMPTYCROSSJOINTOTALS
CALCULATIONCURRENTPASSFORNOT_RELATED_TO_FACTSTREE
CALCULATIONPASSVALUEFREEZENULLTRUE
CALCULATIONSFROMONTUPLETOSTR
CALLGENERATEOPENINGPERIODTYPE
CELLGLOBALORUNION
CELLFORMULASETLISTGROUPPAGESUNIQUE
CHAPTERSGROUPINGPARALLELPERIODUNIQUENAME
CHILDRENHEADPARENTUPDATE
CLEARHIDDENPASSUSE
CLOSINGPERIODHIERARCHIZEPERIODSTODATEUSE_EQUAL_ALLOCATION
COALESCEEMPTYHIERARCHYPOSTUSE_WEIGHTED_ALLOCATION
COLUMNIGNOREPREDICTUSE_WEIGHTED_INCREMENT
COLUMNSIIFPREVMEMBERUSERNAME
CORRELATIONINCLUDEEMPTYPROPERTIESVALIDMEASURE
COUNTINDEXPROPERTYVALUE
COUSININTERSECTQTDVAR
COVARIANCEISRANKVARIANCE
COVARIANCENISANCESTORRECURSIVEVARIANCEP
CREATEISEMPTYRELATIVEVARP
CREATEPROPERTYSETISGENERATIONROLLUPCHILDRENVISUAL
CREATEVIRTUALDIMENSIONISLEAFROOTVISUALTOTALS
CROSSJOINISSIBLINGROWSWHERE
CUBEITEMSCOPEWITH
CURRENTLAGSECTIONSWTD
CURRENTCUBELASTCHILDSELECTXOR
CURRENTMEMBERLASTPERIODSSELFYTD
DEFAULT_MEMBERLASTSIBLINGSELF_AND_AFTER
DEFAULTMEMBERLEADSELF_AND_BEFORE

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

Community Additions

ADD
Show: