Data Source Object

OLE DB Programmer's Reference

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.

1998-2001 Microsoft Corporation. All rights reserved.



Microsoft Ole Db 2.0 Programmer's Reference and Data Access SDK
Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)
ISBN: 0735605904
EAN: 2147483647
Year: 1998
Pages: 1083

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net