Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The following productions for <value_expression_primary> are optional:
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.
<property>[.VALUE] ? Consumers can check the value of the property MDPROP_MDX_QUERYBYPROPERTY to see whether a provider supports this feature.
<simple_case>, <searched_case> ? Consumers can check the value of the property MDPROP_MDX_CASESUPPORT to see whether a provider supports this feature.
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.