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
SYMPTOMSWhen 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.CAUSEThis problem occurs because the Aggregation Design Wizard
ignores the value of the AllMemberAggregationUsage property when the wizard determines candidate aggregations for a measure
group.WORKAROUNDTo 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:
- Open the Analysis Services project in Microsoft Visual Studio
2005.
- Press CTRL+ALT+L to open the
Solution Explorer window, and then double-click the cube that you
want to edit.
- In Cube Designer, click the Cube Structure tab.
- In the Dimensions pane, click the Attributes tab.
- Expand the dimension that you want to regenerate the
aggregations on, and then select an attribute of the dimension.
- Press F4 to display the
Properties window, and then change the value of the
AggregationUsage property of the attribute to
Full.
- Repeat step 4 and step 5 for the remaining attributes of
the dimension.
- 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.
- 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.
Modification Type: | Major | Last Reviewed: | 2/7/2006 |
---|
Keywords: | kbtshoot kbsql2005bi kbsql2005as kbbug KB912390 kbAudDeveloper kbAudITPRO |
---|
|