strange behavior of filter() in SSAS -
01-04-2006
, 04:38 PM
I am executing the following MDX against Adventure Works cube:
with member Measures.Test as
sum(
filter(
Descendants([Promotion].[Promotions], [Promotion].[Promotions].[Promotion
Name], SELF)
,false
)
,1
)
select
[Promotion].[Promotions].members on rows
,[Reseller].[Reseller Type].members on columns
from
[Adventure Works]
where
([Measures].[Test]
,[Date].[Calendar].[Calendar Year].&[2003])
I am expecting CellSet with all nulls, but instead I am getting CellSet with
some rows filled with "1"s.
If I change SUM function to COUNT, I am getting "0"s everywhere.
Does anybody know what is happening? Is that correct behavior of filter() or
not?
Thanks a lot in advance
Andrey |