Keywords

OLE DB Programmer's Reference

When a keyword is used in a query, it must be enclosed in double quotation marks (""). The OLE DB data source object interface IDBInfo::GetKeywords returns all keywords specific to the provider in use, including keywords not listed here.

A consumer can decide which identifier must be quoted by using IDBInfo::GetKeywords.

Note   It is a good practice to quote all identifiers in an MDX expression, whether or not they are keywords. However, it is not necessary to quote a quoted name, such as a unique name returned from a schema rowset.

If the provider also declares itself to be a TDP, it must return (in addition to the following list) keywords found in the reference section under IDBInfo::GetKeywords.

Following is an alphabetical list of the new keywords introduced by MDX.

A

AFTER	AGGREGATE	ANCESTOR
AND	AS	AXIS

B

BACK_COLOR	BASC	BDESC
BEFORE	BEFORE_AND_AFTER	BOTTOMCOUNT
BOTTOMPERCENT	BOTTOMSUM

C

CHAPTERS	CHILDREN	CHILDREN_CARDINALITY
CLOSINGPERIOD	COALESCEEMPTY	COLUMNS
CORRELATION	COUSIN	COVARIANCE
CROSSJOIN	CUBE	CUBE_NAME
CURRENTMEMBER	CASE	CATALOG_NAME
CELL	CELL_ORDINAL

D

DEFAULTMEMBER	DESCENDANTS	DESCRIPTION
DIMENSION	DIMENSION_UNIQUE_NAME	DRILLDOWNLEVEL
DRILLDOWNLEVELBOTTOM	DRILLDOWNLEVELTOP	DRILLDOWNMEMBER
DRILLDOWNMEMBERBOTTOM	DRILLDOWNMEMBERTOP	DRILLUPLEVEL
DRILLUPMEMBER

E

ELSE	EMPTY	END
EXCEPT	EXTRACT

F

FILTER	FIRSTCHILD	FIRSTSIBLING
FONT_FLAGS	FONT_NAME	FONT_SIZE
FORE_COLOR	FORMAT_STRING	FORMATTED_VALUE
FROM

G

GENERATE

H

HIERARCHIZE

HIERARCHY_UNIQUE_NAME

I

IIF	INTERSECT	ISEMPTY
ITEM

L

LAG	LASTCHILD	LASTPERIODS
LASTSIBLING	LEAD	LEVEL_UNIQUE_NAME
LEVELS	LINREGINTERCEPT	LINREGR2
LINREGSLOPE	LINREGVARIANCE

M

MEDIAN	MEMBER	MEMBER_CAPTION
MEMBER_GUID	MEMBER_NAME	MEMBER_ORDINAL
MEMBER_TYPE	MEMBER_UNIQUE_NAME	MEMBERS
MTD

N

NEXTMEMBER

NON

NOT

O

ON	OPENINGPERIOD	OR
ORDER

P

PAGES	PARALLELPERIOD	PARENT
PARENT_LEVEL	PARENT_UNIQUE_NAME	PERIODSTODATE
PREVMEMBER	PROPERTIES

Q

QTD

R

RANK

REFRESH

ROWS

S

SCHEMA_NAME	SECTIONS	SELECT
SELF	SELF_AND_AFTER	SELF_AND_BEFORE
SELF_BEFORE_AFTER	SET	SOLVE_ORDER
STDEV

T

TOGGLEDRILLSTATE	TOPCOUNT	TOPPERCENT
TOPSUM

U

UNION

V

VALUE

VAR

W

WHEN	WHERE	WITH
WTD

X

XOR

Y

YTD

1998-2001 Microsoft Corporation. All rights reserved.