EstimatedSize (Level Interface)

Analysis Services Programming

Analysis Services Programming

EstimatedSize (Level Interface)

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.

Remarks

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.

Note  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 earlier versions of Microsoft® SQL Server™ 2000 Analysis Services.

Example

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

See Also

clsPartitionAnalyzer

Level Interface