AllMemberAggregationUsage Element (ASSL)

Controls how the Aggregation Designer in Microsoft SQL Server 2005 Analysis Services (SSAS) designs aggregations.

Syntax

<CubeDimension>
   ...
   <AllMemberAggregationUsage>...</AllMemberAggregationUsage>
   ...
</CubeDimension>

Element Characteristics

Characteristic Description

Data type and length

String (enumeration)

Default value

Default

Cardinality

0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element

Parent elements

CubeDimension

Child elements

None

Remarks

The value of this element is limited to one of the strings in the following table.

Value Description

Full

Every aggregation for the cube must include the All member.

None

No aggregation for the cube should include the All member.

Unrestricted

No restrictions are placed on the Aggregation Designer.

Default

Same as Unrestricted.

Remarks

The element that corresponds to the parent of AllMemberAggregationUsage in the Analysis Management Objects (AMO) object model is CubeDimension.

See Also

Reference

Cube Element (ASSL)
Dimension Element (ASSL)
Properties (ASSL)

Help and Information

Getting SQL Server 2005 Assistance