Export (0) Print
Expand All

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

 

Community Additions

ADD
Show:
© 2014 Microsoft