Database Reference
In-Depth Information
To build this an initial set of aggregations we'll be running the Aggregation Design
Wizard. This can be run by clicking on the Design Aggregations button on the
toolbar of the Aggregations tab of the Cube Editor. This wizard will analyze the
structure of your cube and dimensions, look at various property values you've set,
and try to come up with a set of aggregations that it thinks should be useful. The one
key piece of information it doesn't have at this point is what queries you're running
against the cube, so some of the aggregations it designs may not prove to be useful in
the long run, but running the wizard is extremely useful for creating a first draft of
your aggregation designs.
You can only design aggregations for one measure group at a time; if you have
more than one partition in the measure group you've selected, the first step of the
wizard asks you to choose which partitions you want to design aggregations for.
An aggregation design can be associated with many partitions in a measure group,
and a partition can be associated with just one aggregation design or none at all.
We recommend that, in most cases, you have just one aggregation design for each
measure group for the sake of simplicity. However, if processing time is limited and
you need to reduce the overall time spent building aggregations, or if query patterns
are different for different partitions within the same measure group, it may make
sense to apply different aggregation designs to different partitions.
The next step of the wizard asks you to review the AggregationUsage property of
all the attributes on all of the cube dimensions in your cube; this property can also be
set on the Cube Structure tab of the Cube Editor.
 
Search WWH ::




Custom Search