Hi

when I use MDX query in Pentaho MDX Query Editor:

Frist:

I use MDX query :

with set T as '[C_T_P.Term_USE].[Term].Members'
select NON EMPTY {[Measures].[count]} ON COLUMNS,
NON EMPTY Filter([T], ([Measures].[count] > 1000.0)) ON ROWS
from [Cube_CTP_Date]
where ([Date.FD].[2011-04-29] : [Date.FD].[2011-05-20])


the result is empty

Than:

I delet function filter

with set T as '[C_T_P.Term_USE].[Term].Members'
select NON EMPTY {[Measures].[count]} ON COLUMNS,
NON EMPTY T ON ROWS
from [Cube_CTP_Date]
where ([Date.FD].[2011-04-29] : [Date.FD].[2011-05-20])


there is data in the result.

Last:

I use the same query as frist,
there is data in the result.


Why?