mondrian - mdx. Filter values from fact table before aggregate -

i have simple cube 2 dimensions: dim1, dim2, , 1 measure - value (aggregator = sum) need cross table via mdx:

select non empty [dim2].members on 0, non empty [measures].value on 1  [cube] 

=>

      el1 el2 el3 el4  value 12  14  45  64  

this values aggregate dim1. ok.

next create calculate measure:

with [measures].value_filter iif([measures].value> 15, [measures].value, null) select non empty [dim2].members on 0, non empty [measures].value_filter on 1 [cube] 

=> correct result:

     el3 el4  value 45 64 

but, how can filter cells non aggregate values of [measures].value, ie real values database?

you can filter members contained in dimension. if want filter on something, has available in cube. hence may potentially have add columns attributes 1 of dimensions.

you filtering follows, assuming want use member1 of hierarchy/attribute hier2 of dimension dim2 filter:

select non empty [dim2].members on 0,        [measures].value on 1    [cube]  ([dim2].[hier2].[member1])