Hi,

I'm trying to rewrite a DSO application in AMO.

There's an example of creating aggregations in DSO at:
http://msdn.microsoft.com/library/de...nalyz_2i42.asp

Is there an example of creating aggregations in AMO?

Thanks

Hmm - you could look at the AMOAdventureWorks OLAP dB sample (part of the
samples that come with AS2k5). Presuming default installation location of
the samples, go to the: C:\Program Files\Microsoft SQL
Server\90\Samples\Analysis Services\Programmability\AMO\AMOAdventureWorks
and inside there you can view example AMO code on how to build aggregations.

A good reference to match the example with the object library is:
http://msdn2.microsoft.com/en-us/lib...S,SQL.90).aspx

If for example, you just want to create a 5% aggregation on a cube partition
(where the partition object is "myPartition"), you can also just C# AMO code
bit like:
// Create Annotation (5% aggregation)
myPartition.Annotations.Add("AggregationPercent", "5");

which performs the task of setting the 5% aggregation within the partition.

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



"Acius" <acius (AT) nospam (DOT) nospam> wrote

Hi,

The only references I can find to Annotations in AMOAdventureWorks are:
part.Annotations.Add("LastOrderDateKey", "184");
part.Annotations.Add("LastOrderDateKey", "549");
part.Annotations.Add("LastOrderDateKey", "914");
Is there a more recent version?

If all I have to do is something like
myPartition.Annotations.Add("AggregationPercent", "5");
That'll get me started

Thanks


"Denny Lee" wrote:

Actually, the AMOAdventureWorks portion is specific to the aggregations of
the AMOAdventureWorks - this is a valid way to create aggregations. As for
the other part about myPartiiton.Annotations.Add - yes, this is a simpler
way for adding a 5% aggregation directly to the cube partition.

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



"Acius" <acius (AT) nospam (DOT) nospam> wrote

Hi Denny,

I think you mean "aggregations", not "annotations". And the Add method just
adds a single aggregation without designing anything. I believe that in AMO,
in order to design an aggregation, you have to go through process of
InitializeDesign, loop through DesignAggregations until the desired limit is
reached, and then FinalizeDesign.

There is an XML/A command "DesignAggregations" that appears to design the
aggregations in one step, but I haven't got it working yet.

Reed


"Denny Lee" wrote: