MS SQL Server OLAP - Partition Mgr/Part Agg Util For Yukon?

Author

Partition Mgr/Part Agg Util For Yukon?

SQL McOLAP

2005-09-29, 9:24 am

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

Chris Webb

2005-09-29, 8:24 pm

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:

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

SQL McOLAP

2005-09-30, 9:23 am

Thanks, Chris!

"Chris Webb" wrote:
[color=darkred]
> 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:
>

Sponsored Links