Microsoft KB Archive/912390

= BUG: SQL Server 2005 Analysis Services still generates aggregations on the (All) member of a dimension when you set the value of the AllMemberAggregationUsage property to None =

Article ID: 912390

Article Last Modified on 2/7/2006

-

APPLIES TO


 * Microsoft SQL Server 2005 Analysis Services

-





SYMPTOMS
When you set the value of the AllMemberAggregationUsage property of a dimension to None in Microsoft SQL Server 2005 Analysis Services, the Aggregation Design Wizard generates aggregations on the (All) member of the dimension.

Note The Aggregation Design Wizard is used to design aggregations for a partition. For more information about the Aggregation Design Wizard, see the &quot;Aggregation Design Wizard&quot; topic in SQL Server Books Online.



CAUSE
This problem occurs because the Aggregation Design Wizard ignores the value of the AllMemberAggregationUsage property when the wizard determines candidate aggregations for a measure group.



WORKAROUND
To work around this problem, you can change the value of the AggregationUsage property of the attribute of the dimension to Full. This change disables aggregations on the (All) member. To do this, follow these steps:
 * 1) Open the Analysis Services project in Microsoft Visual Studio 2005.
 * 2) Press CTRL+ALT+L to open the Solution Explorer window, and then double-click the cube that you want to edit.
 * 3) In Cube Designer, click the Cube Structure tab.
 * 4) In the Dimensions pane, click the Attributes tab.
 * 5) Expand the dimension that you want to regenerate the aggregations on, and then select an attribute of the dimension.
 * 6) Press F4 to display the Properties window, and then change the value of the AggregationUsage property of the attribute to Full.
 * 7) Repeat step 4 and step 5 for the remaining attributes of the dimension.
 * 8) Click the Partitions tab in Cube Designer, expand the partition that you want to generate aggregations on, and then click Design Aggregations to start the Aggregation Design Wizard.
 * 9) Redeploy the project after you finish the Aggregation Design Wizard.

Analysis Services no longer creates aggregations on the (All) member of the dimension.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
To determine whether an aggregation is generated on the (All) member of a dimension, follow these steps:
 * 1) Open SQL Server Management Studio.
 * 2) Connect to Analysis Services, and then expand the Analysis Services database whose aggregations result you want to see.
 * 3) Expand Cubes.
 * 4) Right-click a cube, point to Script Cube As, point to CREATE To, and then click New Query Editor Window.
 * 5) Locate the  tag, and then expand the  tag.

The aggregations that are generated for the cube are listed in separate  tags.

An aggregation that is generated on a specific attribute will have the following entry.  Dimension Name   Attribute Name </Attribute> </Attributes> </Dimension> An aggregation that is generated on the (All) member of a dimension will have the following entry. Note the absence of any Attribute tags. <Dimension> Dimension Name</CubeDimensionID> </Dimension> Note is a placeholder for the name of the dimension. is a placeholder for the name of the attribute.

Keywords: kbtshoot kbbug kbsql2005as kbsql2005bi KB912390

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.