Hi

I am trying to design new aggregations in VBScript. Is this possible?

When I try "oPartitionAnalyzer.NextAnalysisStep(dblPct, dblSize, lCnt)" step
it always fail with the following message: "Type Misamtch". If I don't pass
it any parameters (all three values are output) it says that parameters are
not optional.

Has anyone managed to do this or does it have to be done in VB6?

Thanks

Certainly it is possible with VB6. Find a copy of the SQL Server 2000
Resource Kit and install the Partition Manager Utility. And alternate source
is to install SSABI and look in the tools folder. There was an enhanced
version of the Partition Manager utility called the Partition Aggregation
Utility which allowed additional functionality that SSABI required, such as
resetting the dimension and partition counts by-hand.

The entire utility is written in VB6 and is available in source code.

Another source is the Partition Explorer done by Erik Thomsen for his SQL7
"Microsoft OLAP Solutions" book. It still runs for the most part on SQL 2000
(and source is included there as well). Either purchase Erik's book or look
here:
http://www.dsslab.com/MSOLAPSolutions.html

Hope that helps.


--
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.

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