Performance Optimization - Professional SQL Server Analysis Services 2005 with MDX

Databases Reference

In-Depth Information

the project followed by scripting from SSMS or open the file "Adventure

works.Partitions" in your current project's directory in an XML editor. If you

look at the partition Internet_Sales_2001 you will find the following definition,

which indicates that the partition has an aggregation design defined and the

aggregation design used has the id AggregationDesign.

<ID>Internet_Sales_2001</ID>

<Name>Internet_Sales_2001</Name>

........

<AggregationDesignID>AggregationDesign</AggregationDesignID>

</Partition>

You can find the aggregation designed by the server in the Aggrega-

tionDesign section for the measure group "Internet Sales." Following is a sec-

tion of the definition for the aggregation that has been designed. Each ag-

gregation design can have one or more aggregations defined. The dimension

section within Aggregations includes the estimated counts for dimension at-

tributes. In the aggregation section, it lists the detailed aggregation design for

each aggregation. The definitions for each aggregation contain the combina-

tion of the hierarchies that are to be included for aggregating the data. If a

hierarchy has not been specified in the aggregation design, by default it is im-

plied that the top-level member or the default member of that hierarchy is in-

cluded.

<ID>AggregationDesign</ID>

<Name>AggregationDesign</Name>

Search WWH ::

Custom Search

Home