I need to have two different aggregation designs for a measure group, one
for hourly data and one for daily.

Is it possible to do this within Visual Studio? Both of these aggregations
will use the same fact table, so creating two template partitions is not
possible (not allowed by VS). Basically I want to design aggregations within
Visual Studio and copy these based on processing type. I am using AMO to
process the measure group. It appears that aggregations are linked with
partitions within VS, however under the scenes they are their own separate
object.

In AS2000 I had two template partitions and would clone them based on the
processing type.

TIA,

Jesse.

Replay to this and to your earlier post.

Unfortunately BI Dev studio is missing some functionality in this area.

You can use scripting functionality in SQL Management studio to manage 2
Aggregation designs.
Right click on your Measure Group in SQL Management studio->Script Measure
Group as -> Alter to .... allows you to create a script to modify your
measure group.
You can find partition object and set AggregationDesingID property to
Aggregation design you like.

For instance you can:
First you can build aggregation design #1. Then Script and clear
AggregationDesingID.
Design aggregation design #2 using the same partition.
From this point on you can use script to assign aggregation design to
partitions.

Hope that helps.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote