Count (clsCollection)
Note
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
The Count property of a Decision Support Objects (DSO) collection returns the number of items in the collection. This property does not apply to CustomProperties collections.
Data Type
Integer
Access
Read-only
Note
All collections in the DSO object model are one-based. That is, the first item in the collection has an index of 1 and the last item has an index of Count.
Example
Use the following code to return the number of cubes in an MDStores collection of cubes:
'Assume an object (dsoDB) of ClassType clsDatabase exists
Dim dsoCube As DSO.MDStore
Dim cubeCounter As Integer
For cubeCounter = 1 to dsoDB.MDStores.Count
Set dsoCube = dsoDB.MDStores(cubeCounter)
Debug.Print " Cube Name: " & dsoCube.Name
Next cubeCounter