MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 22: OLE DB for OLAP Objects and Schema Rowsets
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 |