have anyone done this before? appreciate some tips. My AMO code does
create some aggegation elements in cube partition but I'm not sure it's
enough.

Is this code enough if I only want to set the percentage?

ag = new AggregationDesign("ad");
ag.EstimatedPerformanceGain = 42;
myMeasureGroup.AggregationDesigns.Add(ag);
myPartition.Annotations.Add("AggregationPercent",
"42");
myPartition.AggregationDesignID = "ad";

It does create cube with XML showing <AggregationDesign> with ID of
"ad" and from <Partition> a link to this with
<AggregationDesignID>ad</AggregationDesignID>.
What is different from the XMLA created by my AMO code and the XMLA
made from me manually create aggregationdesign is that these things are
missing in XMLA made by AMO code:
the <EstimatedCount>2</EstimatedCount> in dimensions and
<EstimatedRows>2385</EstimatedRows> in <partition>.

IS IT STILL OK?

<Partitions>
<Partition>
<ID>...</ID>
<Name>...</Name>
<Annotations>
<Annotation>
<Name>AggregationPercent</Name>
<Value>42</Value>
</Annotation>
</Annotations>
<Source xsi:type="DsvTableBinding">

<DataSourceViewID>...</DataSourceViewID>
<TableID>...</TableID>
</Source>
<StorageMode>Molap</StorageMode>
<ProcessingMode>Regular</ProcessingMode>
<ProactiveCaching>

<SilenceInterval>-PT1S</SilenceInterval>
<Latency>-PT1S</Latency>

<SilenceOverrideInterval>-PT1S</SilenceOverrideInterval>

<ForceRebuildInterval>-PT1S</ForceRebuildInterval>
<Source
xsi:type="ProactiveCachingInheritedBinding" />
</ProactiveCaching>

<AggregationDesignID>ad</AggregationDesignID>
</Partition>
</Partitions>
<AggregationDesigns>
<AggregationDesign>
<ID>ad</ID>
<Name>ad</Name>
<Dimensions>
<Dimension>

<CubeDimensionID>currency</CubeDimensionID>
<Attributes>
<Attribute>

<AttributeID>currency-KEY</AttributeID>
</Attribute>
<Attribute>

<AttributeID>Currency</AttributeID>
</Attribute>
</Attributes>
</Dimension>


(yes I have posted this to two news groups :-)

This code create an empty aggregationdesign without any aggregation stored
in.
changing the estimatedperformancegain value don't create 42% of
aggregations.

take a look at this sample:
http://msdn2.microsoft.com/en-US/library/ms345091.aspx
(the latest sample code design the aggregations)


<vagle (AT) hsr (DOT) no> wrote

I'm confused.
If I do something like
myPartition.Annotations.Add("AggregationPercent", "42")
It shows up as Molap 42% and has a size of 173 KB (obviously nothing under
rows).
It looks like it's worked .. how do you tell if there are really
aggregations present?

Thanks

"Jéjé" wrote:

to verify which aggregation is used:
go to a partition, open its property page under management studio

and the first value in the property list is the aggregation design ID
this is the current aggregationdesign associated to the partition.

to see the list of the possible aggregation designs, generate the XML/A
script for the measure group and you'll found all the aggregation design
available for this measure group. or use the sample application AMOBrowser
which can display this information too.


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

I'm actually working on a post about this. If you can hold off to Friday
I'll have it done.

<vagle (AT) hsr (DOT) no> wrote

sounds very good! I'll wait .....

Jesse O. wrote:

do I have to process the cube first when calling code like:

while ((!finished) && (optimization < optimizationWanted) && (storage
< maxStorageBytes))
{
ad.DesignAggregations(out optimization, out storage,
out aggCount, out finished);
}


I get this error:
The CurrencyKEY attribute of the Currency dimension has zero values.
The server cannot design aggregations for this attribute




Jesse O. wrote:

see the post here:

http://jesseorosz.spaces.live.com/



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