全部文档
文档中心财务模型多维表达式MDXMDX语法MDX保留关键字

MDX保留关键字


MDX语法具有以下保留字段,因此在对模型别名,维度名,维度成员名等标识符的命名中劲量规避这些字符。如果万一用到了,请在MDX语句中用分隔符:中括号([])区分出来

ABSOLUTE


ACTIONPARAMETERSET

ADDCALCULATEDMEMBERS

AFTER

AGGREGATE

ALL

ALLMEMBERS

ANCESTOR

ANCESTORS

AND

AS

ASC

ASCENDANTS

AVERAGE

AXIS

BASC

BDESC

BEFORE

BEFORE_AND_AFTER

BOTTOMCOUNT

BOTTOMPERCENT

BOTTOMSUM

BY

CACHE

CALCULATE

CALCULATION

CALCULATIONCURRENTPASS

CALCULATIONPASSVALUE

CALCULATIONS

CALL

CELL

CELLFORMULASETLIST

CHAPTERS

CHILDREN

CLEAR

CLOSINGPERIOD

COALESCEEMPTY

COLUMN

COLUMNS

CORRELATION

COUNT

COUSIN

COVARIANCE

COVARIANCEN

CREATE

CREATEPROPERTYSET

CREATEVIRTUALDIMENSION

CROSSJOIN

CUBE

CURRENT

CURRENTCUBE

CURRENTMEMBER

DEFAULT_MEMBER

DEFAULTMEMBER

DESC

DESCENDANTS

DESCRIPTION

DIMENSION

DIMENSIONS

DISTINCT

DISTINCTCOUNT

DRILLDOWNLEVEL

DRILLDOWNLEVELBOTTOM

DRILLDOWNLEVELTOP

DRILLDOWNMEMBER

DRILLDOWNMEMBERBOTTOM

DRILLDOWNMEMBERTOP

DRILLUPLEVEL

DRILLUPMEMBER

DROP

EMPTY

END

ERROR

EXCEPT

EXCLUDEEMPTY

EXTRACT

FALSE

FILTER

FIRSTCHILD

FIRSTSIBLING

FOR

FREEZE

FROM

GENERATE

GLOBAL

GROUP

GROUPING

HEAD

HIDDEN

HIERARCHIZE

HIERARCHY

IGNORE

IIF

INCLUDEEMPTY

INDEX

INTERSECT

IS

ISANCESTOR

ISEMPTY

ISGENERATION

ISLEAF

ISSIBLING

ITEM

LAG

LASTCHILD

LASTPERIODS

LASTSIBLING

LEAD

LEAVES

LEVEL

LEVELS

LINKMEMBER

LINREGINTERCEPT

LINREGPOINT

LINREGR2

LINREGSLOPE

LINREGVARIANCE

LOOKUPCUBE

MAX

MEASURE

MEDIAN

MEMBER

MEMBERS

MEMBERTOSTR

MIN

MTD

NAME

NAMETOSET

NEST

NEXTMEMBER

NO_ALLOCATION

NO_PROPERTIES

NON

NONEMPTYCROSSJOIN

NOT_RELATED_TO_FACTS

NULL

ON

OPENINGPERIOD

OR

PAGES

PARALLELPERIOD

PARENT

PASS

PERIODSTODATE

POST

PREDICT

PREVMEMBER

PROPERTIES

PROPERTY

QTD

RANK

RECURSIVE

RELATIVE

ROLLUPCHILDREN

ROOT

ROWS

SCOPE

SECTIONS

SELECT

SELF

SELF_AND_AFTER

SELF_AND_BEFORE

SELF_BEFORE_AFTER

SESSION

SET

SETTOARRAY

SETTOSTR

SORT

STDDEV

STDDEVP

STDEV

STDEVP

STORAGE

STRIPCALCULATEDMEMBERS

STRTOMEMBER

STRTOSET

STRTOTUPLE

STRTOVAL

STRTOVALUE

SUBSET

SUM

TAIL

THIS

TOGGLEDRILLSTATE

TOPCOUNT

TOPPERCENT

TOPSUM

TOTALS

TREE

TRUE

TUPLETOSTR

TYPE

TYPED

UNION

UNIQUE

UNIQUENAME

UPDATE

USE

USE_EQUAL_ALLOCATION

USE_WEIGHTED_ALLOCATION

USE_WEIGHTED_INCREMENT

USERNAME

VALIDMEASURE

VALUE

VAR

VARIANCE

VARIANCEP

VARP

VISUAL

VISUALTOTALS

WHERE

WITH

WITH_PARENT

WTD

XOR

YTD

回到顶部

咨询热线

400-821-9199

我们使用 ChatGPT,基于文档中心的内容以及对话上下文回答您的问题。

ctrl+Enter to send