EstimatedSize (Level Interface)
.gif "ms133873.note(zh-cn,SQL.90).gif") 注意： |
|---|
| 下一版本的 Microsoft SQL Server 将删除该功能。请不要在新的开发工作中使用该功能，并尽快修改当前还在使用该功能的应用程序。 |
The EstimatedSize property of the Level interface contains the estimated number of members in the level object. This property is used by the partition analyzer when aggregations are designed.
Applies To:clsAggregationLevel, clsCubeLevel, clsDatabaseLevel, clsPartitionLevel
Data Type
Long
Access
Access depends on the value of the ClassType property of the object.
| Class type | Access |
|---|---|
clsDatabaseLevel |
R/W |
clsCubeLevel |
R/W* |
clsPartitionLevel |
R |
clsAggregationLevel |
R |
* Read-only for virtual cube levels.
备注
The EstimatedSize property is used during analysis of a partition when aggregations are designed. The value provided does not need to be precise, but it should be a close approximation.
| 注意： |
|---|
| The EstimatedSize property for an (All) level is read-only and always set to one (1). This is also true for levels that belong to a virtual dimension created by Microsoft® SQL Server™ 7.0 OLAP Services. |
示例
Use the following code to set the size and type values for a new level object:
' 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
请参阅
参考
clsPartitionAnalyzer
Level Interface