Hello again -

Is there an available tool like Partition Manager/Partition Agg Utility for
Yukon yet? I use these tools very often since a lot of cubes I work with are
based upon hudreds of millions, and sometimes billions, of rows. These cubes
have to be carefully aggregted and partitioned and I use these tools often
for aggregation experimentation.

Also, since with many cubes I'll dynamically build and process partitions
via DSO in customized .NET apps, I was wondering if there's any sample code
to do these tasks in the Yukon realm, since I've had no luck trying to tweak
these apps for Yukon.

Any input welcome!

Thanks!

- Phil

I'm not aware of any tools, yet, but I have designed aggregations manually
using SQL Server Management Studio. If you right-click on a measure group and
then script it you will see all the aggregation design templates for that
measure group in the XML that's generated; it's then a fairly easy task to
hack the XML to create new aggregation designs for that measure group. If you
then script a partition you can see the properties which apply an aggregation
design to that partition, and these can altered manually just as easily.

HTH,

Chris
--
Blog at:
http://spaces.msn.com/members/cwebbbi/


"SQL McOLAP" wrote:

Thanks, Chris!

"Chris Webb" wrote: