Data Source Object

Article
07/05/2016

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.