Creating Analysis Services Cubes - SQL Server Analysis Services 2012 Cube Development - page 115

dimension tables. You can also override the estimated counts to increase the likeli-
hood of UBO aggregating data for a specific attribute. Though useful, the UBO wiz-
ard suffers from similar limitations as the aggregation design wizard—it won't con-
sider aggregations over a certain size and counting rows might not work in every
situation. Note that both the wizards allow creating a new aggregation design, mer-
ging new aggregations with the existing aggregation design, and applying designs to
partitions. You also have an option to process the affected partitions immediately.
If you click through the wizard and save the aggregation design, you'll be able to see
this design in SSMS under the aggregation design folder. Right-click on the ag-
gregation design and select the script to new query window option to understand
the difference between aggregation files and aggregation design. For example, the
following is an aggregation design created using the UBO wizard (list of all dimen-
sion attributes is omitted to save space):
<Create xmlns="http://schemas.microsoft.com/
analysisservices/2003/engine">
<ParentObject>
<DatabaseID>ssas_cookbook_chapter3</DatabaseID>
<CubeID>AdventureWorksSample</CubeID>
<MeasureGroupID>Fact Reseller
Sales</MeasureGroupID>
</ParentObject>
<ObjectDefinition>
<AggregationDesignxmlns:xsd="http://www.w3.org/
2001/XMLSchema"xmlns:xsi="http://www.w3.org/
2001/
XMLSchema-instance"xmlns:ddl2="http://schemas.microsoft.com/
analysisservices/2003/engine/
2"xmlns:ddl2_2="http://schemas.microsoft.com/
analysisservices/2003/engine/2/
2"xmlns:ddl100_100="http://schemas.microsoft.com/
analysisservices/2008/engine/100/
100"xmlns:ddl200="http://schemas.microsoft.com/
analysisservices/2010/engine/
200"xmlns:ddl200_200="http://schemas.microsoft.com/
analysisservices/2010/engine/200/
200"xmlns:ddl300="http://schemas.microsoft.com/