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
Inputs tab,
select
Enable for
Auto-aggregate.
-
Click the ellipsis button
next to
Aggregations 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
data query, the selected aggregate functions are automatically applied.