Hi,

I have a calulated member - measure and the calculation in some cases is set
to null, but when I'm looking that value through one of my dimensions, I
would like to filter non empty rows, but it does not remove thoose rows that
have null value.
The thing is that this is not a real null value, because AS presents it to
itself as zero value.

Ideas?


Peace,
Andrej

Try NON EMPTY keyword in the MDX query.

Cheers,
Sanka

Sorry, might not been so clear.

I do use NON EMPTY keyword in MDX, the thing is that if I set calculated
member as null it won't work the NON EMPTY keyword, because it interprets it
as zero value.


Peace,
Andrej



"Sanka" <loonysan (AT) mailcity (DOT) com> wrote

Check out the follwoing links

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/olapdmad/agmdxadvanced_8jcj.asp

http://support.microsoft.com/default.aspx?
scid=http://support.microsoft.com:80/support/kb/articles/Q2
44/6/50.asp&NoWebContent=1

Cheers,
Sanka

THX

Peace,
Andrej

"Sanka" <loonysan (AT) mailcity (DOT) com> wrote