Properties Cross-Reference

The following table lists the properties exposed by various objects in Microsoft® SQL Server™ OLAP Services version 7.0. Different interfaces may implement a property in slightly different ways.

There is no explicit class for virtual cube dimensions, levels, or measures. If a property does not apply to a virtual cube dimension, level, or measure, that fact is noted in the Applies to column.

Property	Applies to	Interface	Description
AggregateFunction	clsAggregationMeasure clsCubeMeasure clsPartitionMeasure	Measure	A value corresponding to the type of aggregation function used for a measure.
AggregationAnalysisInitialized	clsPartitionAnalyzer	n/a	Indicates whether the partition analyzer has been initialized.
AggregationPrefix	clsAggregation clsCube clsDatabase clsPartition	MDStore	Prefix associated with an aggregation in the store.
AggregationUsage	clsCubeDimension clsPartitionDimension	Dimension	Specifies how aggregations are to be designed for a dimension.
Analyzer	clsCube (excluding virtual cubes) clsPartition	MDStore	The analyzer object for the store.
Caption	clsMemberProperty	n/a	A label associated with the member property to be used for display purposes by OLAP clients.
ClassType	clsCubeCommand clsDatabaseCommand	Command	An enumeration constant identifying the specific class type.
ClassType	Collections	n/a	The class type of the collection object.
ClassType	clsDataSource	n/a	An enumeration constant identifying the specific class type.
ClassType	clsAggregationDimension clsCubeDimension clsDatabaseDimension clsPartitionDimension	Dimension	An enumeration constant identifying the specific class type.
ClassType	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	An enumeration constant identifying the specific class type.
ClassType	clsAggregation clsCube clsDatabase clsPartition	MDStore	An enumeration constant identifying the specific class type.
ClassType	clsAggregationMeasure clsCubeMeasure clsPartitionMeasure	Measure	An enumeration constant identifying the specific class type.
ClassType	clsMemberProperty	n/a	An enumeration constant identifying the specific class type.
ClassType	clsCubeRole clsDatabaseRole	Role	An enumeration constant identifying the specific class type.
ClassType	clsServer	n/a	An enumeration constant identifying the specific class type.
CloseQuoteChar	clsDatasource	n/a	The right (closing) quote character used by the source database.
ColumnSize	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	Size of the level aggregation column in an aggregation table.
ColumnType	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	Data type of the level aggregation column in an aggregation table.
CommandType	clsCubeCommand clsDatabaseCommand	Command	An enumeration constant identifying the command option.
Connection	clsDatasource	n/a	A reference to a Microsoft ActiveX® Data Objects (ADO) Connection object, used to connect to a relational database.
ConnectionString	clsDatasource	n/a	A string containing the initialization parameters for the source database.
ContainedClassType	Collections	n/a	The class type of the items contained within the collection.
Count	Collections	n/a	The number of items in a collection.
Count	CustomProperties	n/a	The number of Property objects in a CustomProperties collection.
DataSource	clsAggregationDimension clsCubeDimension (excluding virtual objects) clsDatabaseDimension (excluding virtual objects) clsPartitionDimension (excluding virtual objects)	Dimension	The data source object of a dimension object.
DataType	Property	n/a	The Microsoft Visual Basic® data type of the custom property defined by the Property object.
Description	clsCubeCommand clsDatabaseCommand	Command	The description of the command object.
Description	clsDatasource	n/a	The description of the data source.
Description	clsCubeDimension clsDatabaseDimension clsPartitionDimension	Dimension	The description of the dimension.
Description	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	The description of the level.
Description	clsAggregation clsCube clsDatabase clsPartition	MDStore	The description of the store.
Description	clsAggregationMeasure clsCubeMeasure clsPartitionMeasure	Measure	The description of the measure.
Description	clsMemberProperty	n/a	The description of the member property.
Description	clsCubeRole clsDatabaseRole	Role	The description of the role.
Description	clsServer	n/a	The description of the server.
DimensionType	clsAggregationDimension clsCubeDimension clsDatabaseDimension clsPartitionDimension	Dimension	An enumeration constant identifying the specific type of dimension.
Edition	clsServer	n/a	The edition of the installed OLAP Services.
EnableAggregations	clsCubeLevel clsPartitionLevel	Level	Specifies whether aggregations are to be enabled for the level object.
EstimatedRows	clsAggregation clsCube clsPartition	MDStore	The estimated number of rows in the store.
EstimatedSize	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	The estimated number of members in the level.
EstimatedSize	clsAggregation clsCube clsDatabase clsPartition	MDStore	The estimated size of all rows, in bytes, in the store.
FormatString	clsAggregationMeasure clsCubeMeasure clsPartitionMeasure	Measure	The format used to display the measure values.
FromClause	clsAggregationDimension clsCubeDimension clsDatabaseDimension clsPartitionDimension	Dimension	The SQL FROM clause for the dimension.
FromClause	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	The SQL FROM clause for the level.
FromClause	clsAggregation clsCube (excluding virtual cubes) clsPartition	MDStore	The SQL FROM clause for the store.
IsDefault	clsAggregation clsPartition	MDStore	Indicates whether the store is the default store.
IsDisabled	clsAggregationLevel clsCubeLevel clsPartitionLevel	Level	Indicates whether the level is disabled. Disabled levels are not visible to end users when browsing a cube.
IsInternal	clsAggregationMeasure clsCubeMeasure clsPartitionMeasure	Measure	Indicates whether the measure is internal to the cube, that is, it is used only for calculations of other measures.
IsReadOnly	clsDatasource	n/a	Indicates whether the data source is read-only.
IsReadWrite	clsCube clsDatabase clsPartition	MDStore	Indicates whether the MDStore object is writable.
IsShared	clsAggregationDimension clsCubeDimension clsDatabaseDimension clsPartitionDimension	Dimension	Indicates whether the dimension can be shared among cubes.
IsTemporary	clsAggregationDimension clsCubeDimension clsDatabaseDimension clsPartitionDimension	Dimension	Indicates whether the object is temporary.
IsTemporary	clsAggregation clsCube clsPartition	MDStore	Indicates whether the object is temporary.
IsUnique	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	Indicates whether all members for a level are uniquely identified by the member key column alone.
IsValid	clsCubeCommand clsDatabaseCommand	Command	Indicates whether the Name and Statement properties are empty and that the command object belongs to a collection.
IsValid	clsDatasource	n/a	Indicates whether the structure of the data source object is valid.
IsValid	clsAggregationDimension clsCubeDimension clsDatabaseDimension clsPartitionDimension	Dimension	Indicates whether the dimension structure is valid.
IsValid	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	Indicates whether the level structure is valid.
IsValid	clsAggregation clsCube clsDatabase clsPartition	MDStore	Indicates whether the store object is valid.
IsValid	clsAggregationMeasure clsCubeMeasure clsPartitionMeasure	Measure	Indicates whether the measure object is valid.
IsValid	clsCubeRole clsDatabaseRole	Role	Indicates whether the role structure is valid.
IsValid	clsServer	n/a	Indicates whether the server settings are valid.
JoinClause	clsAggregationDimension clsCubeDimension clsDatabaseDimension clsPartitionDimension	Dimension	The SQL JOIN clause for the dimension.
JoinClause	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	The SQL JOIN clause for the level.
JoinClause	clsAggregation clsCube (excluding virtual cubes) clsPartition	MDStore	The SQL JOIN clause for the store.
LastProcessed	clsAggregationDimension clsCubeDimension clsDatabaseDimension clsPartitionDimension	Dimension	The date and time when the dimension was last processed.
LastProcessed	clsAggregation clsCube clsDatabase clsPartition	MDStore	The date and time when the store was last processed.
LastUpdated	clsAggregationDimension clsCubeDimension clsDatabaseDimension clsPartitionDimension	Dimension	User-specified date. Not used by OLAP Services.
LastUpdated	clsAggregation clsCube clsDatabase clsPartition	MDStore	User-specified date. Not used by OLAP Services.
LevelType	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	An enumeration constant identifying the specific type of level.
LockTimeout	clsServer	n/a	The amount of time until a lock request fails due to timeout.
MemberKeyColumn	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	The name of the column or expression that contains member keys.
MemberNameColumn	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	The name of the column or expression that contains member names.
Name	clsCubeCommand clsDatabaseCommand	Command	The name of the command object.
Name	clsDatasource	n/a	The name of the data source.
Name	clsAggregationDimension clsCubeDimension clsDatabaseDimension clsPartitionDimension	Dimension	The name of the dimension.
Name	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	The name of the level.
Name	clsAggregation clsCube clsDatabase clsPartition	MDStore	The name of the store.
Name	clsAggregationMeasure clsCubeMeasure clsPartitionMeasure	Measure	The name of the measure.
Name	clsMemberProperty	n/a	The name of the member property.
Name	Property	n/a	The unique user-assigned name of the custom property defined by the Property object.
Name	clsCubeRole clsDatabaseRole	Role	The name of the role.
Name	clsServer	n/a	The name of the server.
OlapMode	clsAggregation clsCube (excluding virtual cubes) clsDatabase clsPartition	MDStore	An enumeration constant identifying the type of OLAP mode of the store.
OpenQuoteChar	clsDatasource	n/a	The left (opening) quote character used by the source database.
Ordering	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	Specifies how a level should be ordered.
OrdinalPosition	clsCubeCommand clsDatabaseCommand	Command	The position of the command relative to other commands.
OrdinalPosition	clsAggregationDimension clsCubeDimension clsDatabaseDimension clsPartitionDimension	Dimension	The position of the dimension relative to other dimensions.
OrdinalPosition	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	The position of the level relative to other levels.
OrdinalPosition	clsAggregationMeasure clsCubeMeasure clsPartitionMeasure	Measure	The position of the measure relative to other measures.
OrdinalPosition	clsMemberProperty	n/a	The ordinal position of the MemberProperty object in the MemberProperties collection.
Parent	clsCubecommand clsDatabaseCommand	Command	The parent MDStore object.
Parent	clsDatasource	n/a	The parent MDStore object.
Parent	clsAggregationDimension clsCubeDimension clsDatabaseDimension clsPartitionDimension	Dimension	The parent MDStore object.
Parent	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	The parent Dimension object.
Parent	clsAggregation clsCube clsDatabase clsPartition	MDStore	The parent MDStore object.
Parent	clsAggregationMeasure clsCubeMeasure clsPartitionMeasure	Measure	The parent MDStore object.
Parent	clsMemberProperty	n/a	The parent Level object.
Parent	clsPartitionAnalyzer	n/a	Contains a reference to the parent MDStore (ClassType clsPartition) object.
Parent	clsCubeRole clsDatabaseRole	Role	The parent MDStore object.
Parent	clsServer	n/a	Contains a reference to the App object.
Permissions	clsCubeRole	Role	The role permissions for the specific key.
Server	clsAggregation clsCube clsDatabase clsPartition	MDStore	The DSO.Server object.
ServiceState	clsServer	n/a	Contains the state of the OLAP server service (MSSQLServer OLAPService).
SliceValue	clsPartitionLevel	Level	The name of the level member used to define a partition slice.
SourceColumn	clsAggregationMeasure clsCubeMeasure clsPartitionMeasure	Measure	The name of the column in the measure fact table that is aggregated.
SourceColumn	clsMemberProperty	n/a	The dimension table name and column that contains values for the MemberProperty.
SourceColumnType	clsAggregationMeasure clsCubeMeasure clsPartitionMeasure	Measure	The measure source column data type.
SourceTable	clsCubeDimension clsDatabaseDimension clsPartitionDimension	Dimension	The name of the source table for the dimension.
SourceTable	clsAggregation clsCube clsPartition	MDStore	The name of the source table of a store.
SourceTableFilter	clsCube (excluding virtual cubes) clsPartition	MDStore	The SQL statement that specifies the source table records to included in the store.
Statement	clsCubeCommand clsDatabaseCommand	Command	The text of the command statement.
State	clsAggregationDimension clsDatabaseDimension	Dimension	Indicates the difference between the dimension object referenced by the client application and the corresponding dimension on the OLAP server.
State	clsCube clsDatabase clsPartition	MDStore	Indicates the difference between the MDStore object referenced by the client application and the corresponding MDStore object on the OLAP server.
State	clsServer	n/a	Indicates the status of the connection to the OLAP server.
SubClassType	clsCubeCommand clsDatabaseCommand	Command	An enumeration constant identifying the subclass type of the object.
SubClassType	clsDatasource	n/a	An enumeration constant identifying the subclass type of the object.
SubClassType	clsAggregationDimension clsCubeDimension clsDatabaseDimension clsPartitionDimension	Dimension	An enumeration constant identifying the subclass type of the object.
SubClassType	clsAggregationLevel clsCubeLevel clsDatabaseLevel clsPartitionLevel	Level	An enumeration constant identifying the subclass type of the object.
SubClassType	clsAggregation clsCube clsDatabase clsPartition	MDStore	An enumeration constant identifying the subclass type of the object.
SubClassType	clsAggregationMeasure clsCubeMeasure clsPartitionMeasure	Measure	An enumeration constant identifying the subclass type of the object.
SubClassType	clsMemberProperty	n/a	An enumeration constant identifying the subclass type of the object.
SubClassType	clsCubeRole clsDatabaseRole	Role	An enumeration constant identifying the subclass type of the object.
SupportedTxnDDL	clsDatasource	n/a	The value of the connection object’s Transaction DDL (data definition language) property, which indicates the source database’s ability to support DDL statements in transactions.
Timeout	clsServer	n/a	The amount of time until a timeout error occurs during processing.
UsersList	clsCubeRole clsDatabaseRole	Role	A semicolon-delimited list of users.
Value	Property	n/a	Can contain any value that is valid for the DataType defined for the Property object.