mdx-reserved-words.md

title	MDX Reserved Words | Microsoft Docs
ms.date	06/04/2018
ms.prod	sql
ms.technology	analysis-services
ms.custom	mdx
ms.topic	reference
ms.author	owend
ms.reviewer	owend
author	minewiskan

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

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