MDAC 2.5 SDK - OLE DB Programmer's Reference
Appendix C: OLE DB Properties


 

MDPROP_MDX_NONMEASURE_EXPRESSIONS

Property group: Data Source Information

Property set: DBPROPSET_DATASOURCEINFO

Type: VT_I4

Typical R/W: R

Description: The capabilities in the <numeric_value_expression> argument of set functions

This is an OLE DB for OLAP property.

Value Meaning
MDPROPVAL_MNE_MEASURESONLY The provider supports only expressions involving Measures dimension members.
MDPROPVAL_MNE_ALLDIMENSIONS The provider supports expressions involving members from any dimension.

Example   Revenue and Cost are measures, and USA is a member of the Geography dimension. In this case, in set functions that take a <numeric_value_expression> argument, expressions such as Revenue/3 and (Revenue - Cost)/Cost*100 are made of measures only. However, expressions such as (USA, Sales)/3 are made of measures and nonmeasures.