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. |