Parole riservate MDXMDX Reserved Words

QUESTO ARGOMENTO SI APPLICA A:sìSQL Server (a partire dalla versione 2008)noDatabase SQL di AzurenoAzure SQL Data Warehouse noParallel Data Warehouse THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Nella tabella seguente vengono elencate le parole riservate MDX (Multidimensional Expressions).The following table contains words reserved for use by Multidimensional Expressions (MDX). Queste parole non devono essere utilizzate come parte di un identificatore, ad esempio un nome di cubo, o come nome di funzione definita dall'utente.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
ANDAND 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 OPPUREOR 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 RADICEROOT VISUALTOTALSVISUALTOTALS
CROSSJOINCROSSJOIN ISSIBLINGISSIBLING ROWSROWS WHEREWHERE
CUBECUBE ITEMITEM SCOPESCOPE conWITH
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

Vedere ancheSee Also

Parole chiave riservate ( La sintassi MDX ) Reserved Keywords (MDX Syntax)
Riferimenti al linguaggio MDX ( MDX )MDX Language Reference (MDX)