DesignedAggregations

The clsPartitionAnalyzer DesignedAggregations collection contains aggregations that have been manually added using the AddExistingAggregation method or automatically generated using the NextAnalysisStep method. At the conclusion of the clsPartitionAnalyzer session you can either choose to save these aggregations in the partition or discard them.

Data Type

Microsoft® Visual Basic® collection containing objects of ClassType clsAggregation.

Access

Read-only

Example

Use the following code to repeatedly invoke the NextAnalysisStep method and then save the DesignedAggregations in a Visual Basic collection. The analysis continues until one of the following two goals is reached:

• Twenty or more aggregations are designed.
• The storage requirements for the designed aggregations exceed 100,000 bytes.

For more information, see InitializeDesign.

'Assume the existence of an object (dsoPartAnalyzer) of ClassType
'clsPartitionAnalyzer

Private blnStopAdding     As Boolean

Private colDesignedAggs   As Collection

dsoPartAnalyzer.InitializeDesign

'Iterate thru analysis until either goal is reached

Do Until blnStopAdding 

    If Not dsoPartAnalyzer.NextAnalysisStep(dblPercentageBenefit, _

    dblAccumulatedSize, lngAggregationsCount) Then

        blnStopAdding = True  'No New Aggregations Designed

    Else

        blnStopAdding = (lngAggregationsCount >= 20) Or _

        (dblAccumulatedSize >= 100000)

    End If

Loop

'Save the designed aggregations into VB collection object

Set colDesignedAggs = dsoPartAnalyzer.DesignedAggregations

This example is for illustrative purposes only. Saving the designed aggregations in a collection in the above manner is not necessary when using an object of ClassType clsPartitionAnalyzer.

See Also