Share via

2.2.4.2.2.12 AggregationDesign

  • Article

This complex type represents a group of aggregations for the MeasureGroup.

   <xsd:complexType name="AggregationDesign">
     <xsd:all>
       <!--These elements are common to each MajorObject-->
       <xsd:element name="Name"  type="xsd:string" />
       <xsd:element name="ID"  type="xsd:string" minOccurs="0" />
       <xsd:element name="CreatedTimestamp" type="xsd:dateTime" minOccurs="0" />
       <xsd:element name="LastSchemaUpdate" type="xsd:dateTime" minOccurs="0" />
       <xsd:element name="Description" type="xsd:string" minOccurs="0" />
       <xsd:element name="Annotations"  minOccurs="0" >
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="Annotation" type="Annotation" minOccurs="0"
                          maxOccurs="unbounded" />
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <!--Extended elements for AggregationDesign object-->
       <xsd:element name="EstimatedRows" type="xsd:long" minOccurs="0"/>
       <xsd:element name="Dimensions" minOccurs="0">
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="Dimension"  type="AggregationDesignDimension"
                  minOccurs="0" maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:element name="Aggregations" minOccurs="0">
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="Aggregation"  type="Aggregation" minOccurs="0"
                          maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:element name="EstimatedPerformanceGain" type="xsd:integer"
                    minOccurs="0"/>
     </xsd:all>
   </xsd:complexType>
           

Element

Read-Only

Default value

Description

EstimatedRows

Empty

The estimated average number of rows in the partition for the partitions that share this design. If this value is not set in the Create command, the system will compute a value.

Dimensions

Empty

A collection of Dimension objects.

Aggregations

Empty

A collection of Aggregation objects.

EstimatedPerformanceGain

The estimated performance gain of the partition, expressed as a percentage.