| vagle@hsr.no 2006-11-14, 7:14 pm |
| 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. EstimatedPerformance
Gain = 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>
< SilenceOverrideInter
val>-PT1S</ SilenceOverrideInter
val>
< ForceRebuildInterval
>-PT1S</ ForceRebuildInterval
>
<Source
xsi:type=" ProactiveCachingInhe
ritedBinding" />
</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>
|