The aggregate "Bad Agg" in the query below is causing no results to be returned.
Notice that there are two members in the set of "Bad Agg". If I remove one or the other from the set (and create a set of just one member) then I get valid results.
Does anybody know what might be happening We are on the latest SP (9.00.3042).
Note that SP/LU below are the "product type". And POLYSTYRENE is the "product species". It is the same species within both product types.
WITH
MEMBER [Product].[Product Species].[Bad Agg] AS'Aggregate ( {
[Product].[Product Species].[Type].&[SP].[POLYSTYRENE],
[Product].[Product Species].[Type].&[LU].[POLYSTYRENE] } )'
SELECT
NON
EMPTY HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({[Product].[Product Indexing].[All]})})) ON COLUMNSFROM
[Sales Budget and Activity]WHERE
([Measures].[Sales],[Product].[Product Species].[Bad Agg],
[Time].[Time F].[Year].[Y 2007])