I need to have a measure group with two template partitions. These
partitions have different aggregations based on the type of partitioning
(hour vs. hourly).

In the designer it will not allow me to add another partition with the same
fact table. When my code runs, it simple clones the appropriate partition.

Any other way to do this? It's throwing and will not enabled the Next or
Finish button :

The 'dbo.vFact_Table' table is currently used by the 'tDay' partition, and
you have not supplied a query to restrict its rows. Measure data may be
counted twice if you use this table in another partition.

In AS2005 aggregations are not specific to the particular partitions.
AggregationDesign object contains definitions of aggregations.
This allows you easily to apply aggregation design to any partition.

You simply don't need your "template" partitions, just create a partition
and point AggregationDesignID property to the particular aggregation design
object.

Try and use AmoBrowser sample application to navigate list of objects in
AMO.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights


"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote

Thanks for the reply.

However, I want two aggregation designs for the same measure group. I don't
see anywhere within VS that you can edit an aggregation without having to go
within a partition. In AMO Browser AggregationDesigns is separate from
Partitions.

"Edward Melomed [MSFT]" <edwardm (AT) norely (DOT) micrsoft.com> wrote