The EstimatedSize property of the Level interface contains the estimated number of members in the level object. The EstimatedSize property is used by the partition analyzer when designing aggregations.
| clsAggregationLevel | clsDatabaseLevel |
| clsCubeLevel | clsPartitionLevel |
Long
The access type depends on the level object class.
| Class | Access |
|---|---|
| clsDatabaseLevel | R/W |
| clsCubeLevel | R |
| clsPartitionLevel | R |
| clsAggregationLevel | R |
The EstimatedSize property is used during analysis of a partition for designing aggregations. The value does not need to be precise, but a close approximation should be provided.
' 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
Note The EstimatedSize property for the (All) level is read-only and always returns 1.
| About Decision Support Objects | Using Decision Support Objects |
| Properties Cross-Reference |