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.

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.