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 multidimensional schema object names can be qualified in an MDX expression.

MDPROP_MDX_OUTERREFERENCE

Support for an outer reference 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_FUNCTIONS

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.