The auto-aggregate feature
is a productivity feature that enables you to specify a set of aggregations
to apply as default aggregations to numeric columns for a specific
table. A typical use is to automatically aggregate some of the columns
in a fact table.
To use the auto-aggregate
feature:
-
Select a table on the
Design tab.
On the
Properties tab, the table properties
are displayed.
-
Select
Enable for
Auto-Aggregate.
-
Click the ellipsis button
next to
Functions to open the
Choose
Aggregations window.
-
Select the check boxes
for the aggregate functions that you want to apply, and then click
Apply.
Whenever you add a column
to the query, the selected aggregate functions are automatically applied.