MDX 예약어MDX Reserved Words

이 항목은 다음에 적용됩니다.예SQL Server(2008부터)아니요Azure SQL Database아니요Azure SQL Data Warehouse 아니요병렬 데이터 웨어하우스 THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

다음 표에서는 MDX에서 사용하기 위한 예약어를 보여 줍니다.The following table contains words reserved for use by Multidimensional Expressions (MDX). 다음 예약어는 MDX에서 큐브 이름 또는 사용자 정의 함수 이름과 같은 식별자로 사용할 수 없습니다.You should not use these words as part of any identifier, such as a cube name, or user-defined function name, in MDX.

ABSOLUTEABSOLUTE DESCDESC LEAVESLEAVES SELF_BEFORE_AFTERSELF_BEFORE_AFTER
ACTIONPARAMETERSETACTIONPARAMETERSET DESCENDANTSDESCENDANTS LEVELLEVEL SESSIONSESSION
ADDCALCULATEDMEMBERSADDCALCULATEDMEMBERS DESCRIPTIONDESCRIPTION LEVELSLEVELS SETSET
AFTERAFTER DIMENSIONDIMENSION LINKMEMBERLINKMEMBER SETTOARRAYSETTOARRAY
AGGREGATEAGGREGATE DIMENSIONSDIMENSIONS LINREGINTERCEPTLINREGINTERCEPT SETTOSTRSETTOSTR
ALLALL DISTINCTDISTINCT LINREGPOINTLINREGPOINT SORTSORT
ALLMEMBERSALLMEMBERS DISTINCTCOUNTDISTINCTCOUNT LINREGR2LINREGR2 STDDEVSTDDEV
ANCESTORANCESTOR DRILLDOWNLEVELDRILLDOWNLEVEL LINREGSLOPELINREGSLOPE STDDEVPSTDDEVP
ANCESTORSANCESTORS DRILLDOWNLEVELBOTTOMDRILLDOWNLEVELBOTTOM LINREGVARIANCELINREGVARIANCE STDEVSTDEV
AND DRILLDOWNLEVELTOPDRILLDOWNLEVELTOP LOOKUPCUBELOOKUPCUBE STDEVPSTDEVP
ASAS DRILLDOWNMEMBERDRILLDOWNMEMBER MAXMAX STORAGESTORAGE
ASCASC DRILLDOWNMEMBERBOTTOMDRILLDOWNMEMBERBOTTOM MEASUREMEASURE STRIPCALCULATEDMEMBERSSTRIPCALCULATEDMEMBERS
ASCENDANTSASCENDANTS DRILLDOWNMEMBERTOPDRILLDOWNMEMBERTOP MEDIANMEDIAN STRTOMEMBERSTRTOMEMBER
AVERAGEAVERAGE DRILLUPLEVELDRILLUPLEVEL MEMBERMEMBER STRTOSETSTRTOSET
AXISAXIS DRILLUPMEMBERDRILLUPMEMBER MEMBERSMEMBERS STRTOTUPLESTRTOTUPLE
BASCBASC DROPDROP MEMBERTOSTRMEMBERTOSTR STRTOVALSTRTOVAL
BDESCBDESC EMPTYEMPTY MINMIN STRTOVALUESTRTOVALUE
BEFOREBEFORE ENDEND MTDMTD SUBSETSUBSET
BEFORE_AND_AFTERBEFORE_AND_AFTER ERRORERROR NAMENAME SUMSUM
BOTTOMCOUNTBOTTOMCOUNT EXCEPTEXCEPT NAMETOSETNAMETOSET TAILTAIL
BOTTOMPERCENTBOTTOMPERCENT EXCLUDEEMPTYEXCLUDEEMPTY NESTNEST THISTHIS
BOTTOMSUMBOTTOMSUM EXTRACTEXTRACT NEXTMEMBERNEXTMEMBER TOGGLEDRILLSTATETOGGLEDRILLSTATE
BYBY FALSEFALSE NO_ALLOCATIONNO_ALLOCATION TOPCOUNTTOPCOUNT
CACHECACHE FILTERFILTER NO_PROPERTIESNO_PROPERTIES TOPPERCENTTOPPERCENT
CALCULATECALCULATE FIRSTCHILDFIRSTCHILD NONNON TOPSUMTOPSUM
CALCULATIONCALCULATION FIRSTSIBLINGFIRSTSIBLING NONEMPTYCROSSJOINNONEMPTYCROSSJOIN TOTALSTOTALS
CALCULATIONCURRENTPASSCALCULATIONCURRENTPASS FORFOR NOT_RELATED_TO_FACTSNOT_RELATED_TO_FACTS trEETREE
CALCULATIONPASSVALUECALCULATIONPASSVALUE FREEZEFREEZE NULLNULL TRUETRUE
CALCULATIONSCALCULATIONS FROMFROM ONON TUPLETOSTRTUPLETOSTR
CALLCALL GENERATEGENERATE OPENINGPERIODOPENINGPERIOD TYPETYPE
CELLCELL GLOBALGLOBAL OROR UNIONUNION
CELLFORMULASETLISTCELLFORMULASETLIST GROUPGROUP PAGESPAGES UNIQUEUNIQUE
CHAPTERSCHAPTERS GROUPINGGROUPING PARALLELPERIODPARALLELPERIOD UNIQUENAMEUNIQUENAME
CHILDRENCHILDREN HEADHEAD PARENTPARENT UPDATEUPDATE
CLEARCLEAR HIDDENHIDDEN PASSPASS USEUSE
CLOSINGPERIODCLOSINGPERIOD HIERARCHIZEHIERARCHIZE PERIODSTODATEPERIODSTODATE USE_EQUAL_ALLOCATIONUSE_EQUAL_ALLOCATION
COALESCEEMPTYCOALESCEEMPTY HIERARCHYHIERARCHY POSTPOST USE_WEIGHTED_ALLOCATIONUSE_WEIGHTED_ALLOCATION
COLUMNCOLUMN IGNOREIGNORE PREDICTPREDICT USE_WEIGHTED_INCREMENTUSE_WEIGHTED_INCREMENT
COLUMNSCOLUMNS IIFIIF PREVMEMBERPREVMEMBER USERNAMEUSERNAME
CORRELATIONCORRELATION INCLUDEEMPTYINCLUDEEMPTY PROPERTIESPROPERTIES VALIDMEASUREVALIDMEASURE
COUNTCOUNT INDEXINDEX PROPERTYPROPERTY VALUEVALUE
COUSINCOUSIN INTERSECTINTERSECT QTDQTD VARVAR
COVARIANCECOVARIANCE ISIS RANKRANK VARIANCEVARIANCE
COVARIANCENCOVARIANCEN ISANCESTORISANCESTOR RECURSIVERECURSIVE VARIANCEPVARIANCEP
CREATECREATE ISEMPTYISEMPTY RELATIVERELATIVE VARPVARP
CREATEPROPERTYSETCREATEPROPERTYSET ISGENERATIONISGENERATION ROLLUPCHILDRENROLLUPCHILDREN VISUALVISUAL
CREATEVIRTUALDIMENSIONCREATEVIRTUALDIMENSION ISLEAFISLEAF ROOTROOT VISUALTOTALSVISUALTOTALS
CROSSJOINCROSSJOIN ISSIBLINGISSIBLING ROWSROWS WHEREWHERE
CUBECUBE ITEMITEM SCOPESCOPE 의 모든 멘션을WITH
CURRENTCURRENT LAGLAG SECTIONSSECTIONS WTDWTD
CURRENTCUBECURRENTCUBE LASTCHILDLASTCHILD SELECTSELECT XORXOR
CURRENTMEMBERCURRENTMEMBER LASTPERIODSLASTPERIODS SELFSELF YTDYTD
DEFAULT_MEMBERDEFAULT_MEMBER LASTSIBLINGLASTSIBLING SELF_AND_AFTERSELF_AND_AFTER
DEFAULTMEMBERDEFAULTMEMBER LEADLEAD SELF_AND_BEFORESELF_AND_BEFORE

관련 항목:See Also

예약 된 키워드 ( MDX 구문 ) Reserved Keywords (MDX Syntax)
MDX 언어 참조 ( Mdx)MDX Language Reference (MDX)