Some calculated values missing with a hierarchy aggregator .

[mysticfall]

When you specify a SUM type hierarchy aggregator to the column axis, some of the aggregated values are not showing up(i.e. USA, Mexico, Canada).

SELECT {[Measures].[Unit Sales]} ON COLUMNS, Hierarchize(Union(Union(CrossJoin({[Product].[All Products]}, {[Gender].[All Gender]}), CrossJoin({[Product].[All Products]}, [Gender].[All Gender].Children)), {([Product].[Drink], [Gender].[All Gender]), ([Product].[Non-Consumable], [Gender].[All Gender]), ([Product].[Food], [Gender].[All Gender])})) ON ROWS FROM [Sales]

[mysticfall]

• Should remove aggregated cells on [Product].[All Products] as they are redundant.
• Should exclude measures of [Product].[All Products] in calculation to avoid getting doubled result.

Currently, test cases for AggregatorHideParentIT and AggregatorFullIT shows this defect and should be updated accordingly.