MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 22: OLE DB for OLAP Objects and Schema Rowsets


 

Data Source Object

OLE DB for OLAP adds a number of properties to the DBPROPSET_DATASOURCEINFO property set of a data source object. These properties give the consumer information about variations among multidimensional providers.

Property Short description
MDPROP_FLATTENING_SUPPORT Flattening support.
MDPROP_NAMED_LEVELS Support for named levels.

A bitmask specifying whether the provider supports named levels and/or numbered levels.

DBPROP_DATASOURCE_TYPE Data source type.
MDPROP_MDX_JOINCUBES Support for query-joining multiple cubes.
MDPROP_AXES Number of axes in the dataset.

The value of this property is the maximum number of axes that the provider supports in the dataset. To be compliant with OLE DB for OLAP, this value must be at least 3.

MDPROP_AGGREGATECELL_UPDATE Support for updating aggregated cells.
MDPROP_RANGEROWSET Support for cell updates.
MDPROP_MDX_SLICER The capabilities in the WHERE clause of an MDX statement.
MDPROP_MDX_OBJQUALIFICATION Provider's ability to qualify a cube name.

A bitmask specifying how MD schema object names can be qualified in an MDX expression.

MDPROP_MDX_OUTERREFERENCE Support for outer references in an MDX statement.
MDPROP_MDX_QUERYBYPROPERTY Support for querying by property values in an MDX statement.
MDPROP_MDX_CASESUPPORT Support for MDX case statements.

A bitmask specifying the support in a provider for case statements.

MDPROP_MDX_STRING_COMPOP Support for string comparison operators other than equals and not-equals operators.

A bitmask specifying the support in a provider for string comparison operators.

MDPROP_MDX_DESCFLAGS Support for various <desc flag> values in the DESCENDANTS function.
MDPROP_MDX_SET_FUNCTION Support for various set functions.
MDPROP_MDX_MEMBER_FUNCTIONS Support for various member functions.
MDPROP_MDX_NUMERIC_FUNCTIONS Support for various numeric functions.
MDPROP_MDX_FORMULAS Support for creation of named sets and calculated members.
MDPROP_MDX_NONMEASURE_EXPRESSIONS The capabilities in the <numeric_value_expression> argument of set functions.