The ColumnType property of the Level interface contains the data type of the level aggregation column in an aggregation table.
| clsAggregationLevel | clsDatabaseLevel |
| clsCubeLevel | clsPartitionLevel |
ADODB.DataTypeEnum (an enumeration)
ColumnType is set to one of the following enumerated values.
| ColumnTypeName | Value |
|---|---|
| Big Integer | adBigInt |
| Binary | adBinary |
| Boolean | adBoolean |
| String (Unicode) | adBSTR |
| Char | adChar |
| Currency | adCurrency |
| Date | adDate |
| Date | adDBDate |
| Time | adDBTime |
| Date & Time | AdDBTimeStamp |
| Decimal | adDecimal |
| Double | adDouble |
| Integer | adInteger |
| Numeric | adNumeric |
| Single | adSingle |
| Small Integer | adSmallInt |
| Tiny Integer | adTinyInt |
| Unsigned Big Integer | adUnsignedBigInt |
| Unsigned Integer | adUnsignedInt |
| Unsigned Small Integer | adUnsignedSmallInt |
| Unsigned Tiny Integer | adUnsignedTinyInt |
| Char (Unicode) | adWChar |
| Text | adChar |
The access type depends on the level object class.
| Class | Access |
|---|---|
| clsDatabaseLevel | R/W |
| clsCubeLevel | R |
| clsPartitionLevel | R |
| clsAggregationLevel | R |
The ColumnType and ColumnSize properties are required only when the storage mode for a cube is ROLAP. These values are used in defining the columns in the relational database table which will store the aggregation values. For more information, see Storage Modes (MOLAP, ROLAP, HOLAP).
Use the following code to specify a small integer ColumnType:
' Assume an object (dsoDim) of ClassType clsDimension exists
Set dsoLev = dsoDim.Levels.AddNew("Store Id")
dsoLev.MemberKeyColumn = """store"".""store_number"""
dsoLev.ColumnSize = 4
dsoLev.ColumnType = adInteger
dsoLev.EstimatedSize = 24
| About Decision Support Objects | Using Decision Support Objects |
| Properties Cross-Reference |