Summarizing Member Sets
When you work with dimensional data sources
and you summarize member sets, if an explicit summary function such
as Total is used and the set contains duplicates,
the result is double-counted. If you are using an OLAP data source,
the result produced for the automatic summary function depends on
the data source.
For example, the following product line rows were defined using the expression
union ([Product line], [Camping Equipment], ALL)
where [Product line] is the level that contains Camping Equipment.
Figure 1. Crosstab showing revenue by product line
with an aggregate row and a total row
For PowerCubes, Aggregate (Product line) is the sum of the product lines excluding duplicates. For more information about how the aggregate function is processed, see Summary Functions.