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 (912390)



The information in this article 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 "Aggregation Design Wizard" 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 "Applies to" 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 <Aggregations> tag, and then expand the <Aggregations> tag.

    The aggregations that are generated for the cube are listed in separate <Aggregation> tags.
An aggregation that is generated on a specific attribute will have the following entry.
<Dimension>
    <CubeDimensionID>Dimension Name</CubeDimensionID>
        <Attributes>
            <Attribute>
                <AttributeID>Attribute Name</AttributeID>
            </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>
    <CubeDimensionID>Dimension Name</CubeDimensionID>
</Dimension>
NoteDimension Name is a placeholder for the name of the dimension. Attribute Name is a placeholder for the name of the attribute.

Modification Type:MajorLast Reviewed:2/7/2006
Keywords:kbtshoot kbsql2005bi kbsql2005as kbbug KB912390 kbAudDeveloper kbAudITPRO