Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)

2017-07-07 02:10:07

OLE DB Programmer's Reference

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_NME_MEASURESONLY	The provider supports only expressions involving Measures dimension members.
MDPROPVAL_NME_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.

Value

Meaning

MDPROPVAL_NME_MEASURESONLY

The provider supports only expressions involving Measures dimension members.

MDPROPVAL_NME_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.

Категории