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
a 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.