MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 25: MDX Grammar

General Leveling Rules for MDX Statements

The following productions for <value_expression_primary> are optional:

1. The ability to qualify <tuple>[.VALUE] by <cube_name> in a value expression primary is optional. Consumers can check the value of the property MDPROP_MDX_OUTERREFERENCE to see whether a provider supports this feature.
   
   
2. <property>[.VALUE]—Consumers can check the value of the property MDPROP_MDX_QUERYBYPROPERTY to see whether a provider supports this feature.
   
   
3. <simple_case>, <searched_case>—Consumers can check the value of the property MDPROP_MDX_CASESUPPORT to see whether a provider supports this feature.

   Note   The syntax of <value_expression> is generally the same as SQL-92, subclause 6.11, <value_expression>. Differences are as follows:

   • <tuple>[.VALUE], <property>[.VALUE] and <conditional_expression> are new values for <value_expression_primary>.
     
     
   • There are new values for <numeric_value_function>, mainly for statistical analysis.
     
     
   • The BNF for <value_expression_primary>, <character_string_literal>, and <string_value_expression> have been shortened by eliminating several intermediate nonterminals.