Hi,

I'm using DSO to set aggregations in a partition. Using
the following code I can add additional aggregations to
the existing ones.

For Each dsoAggregation In
dsoPartitionAnalyzer.DesignedAggregations
dsoPartition.MDStores.Add dsoAggregation, 1
Next

Q - how do I replace the existing aggreagations?

Ta!
Paul

Look at the sample code in the Partition Manager in the SQL Server 2000
Resource Kit. It allows you to add/remove/edit aggregates by-hand. The VB6
code is included in the kit.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Paul" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Dave,

Thanks for the info. I haven't been able to find any for
sale as it seems to be out of print, but a collegue is
lending me a copy.

Ta
Paul