I have problem, I do not know how to write MDX, for specific question.
I must sum one of the Measures, but I must to do it by measure value
It is very easy to write in SQL
Select sum(income)
from Sales
where income>10
but I have problem to write it in MDX
I need to sum this by all dimensions (dim1... dim25), but only choose
that cells, where it's value (income) is greater then 10.
It wouldn't be a problem if I could build Calculated Measure like:
iif([Measures].[Ms]>-20000,10,0)
but it is a great problem to write it in MDX (or rather generate it,
when I do not know about all user filters.) My users can "building"
their MDX queries (without knowlage of it :P), but they can filtr only
by dimensions. How to filt by measures value?
Please help me
LS