다음을 통해 공유


MDX 예약어

다음 표에서는 MDX에서 사용하기 위한 예약어를 보여 줍니다. 다음 예약어는 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

 

참고 항목

개념

예약어(MDX 구문)
MDX 언어 참조(MDX)

도움말 및 정보

SQL Server 2005 지원 받기