According to KB#244650, null values in the fact table are treated as zero. Therefore, there isn't any case where a physical measure is empty and another physical measure in the same tuple is not empty.

NON_EMPTY_BEHAVIOR accepts only physical measures. Since either all physical measures in a tuple are empty, or they are all nonempty, it should not matter which measure is selected as NON_EMPTY_BEHAVIOR.

Am I correct, or am I missing something?
I would be very glad to hear a response from Microsoft.
Sincerely.
Elyo

My question is only for regular cubes
(In virtual cubes, some measures may be empty while others are not empty)

Ely

----- Elyo Ravuna wrote: ----

According to KB#244650, null values in the fact table are treated as zero. Therefore, there isn't any case where a physical measure is empty and another physical measure in the same tuple is not empty.

NON_EMPTY_BEHAVIOR accepts only physical measures. Since either all physical measures in a tuple are empty, or they are all nonempty, it should not matter which measure is selected as NON_EMPTY_BEHAVIOR

Am I correct, or am I missing something
I would be very glad to hear a response from Microsoft
Sincerely
Elyo

I think the relevant point is not that if a dimension member value is empty
or not.

Remember the power of olap is Multidimensional analysis, so NON EMPTY is
usefull to unhide NULL CROSSJOINS, ie, if you have two dimensions that for a
certain level they do not have a valid cross (or for the hole tuple) then
NON EMPTY operator will exlude that tuple from the display.

Hope it helps,

Michael Prendergast
DataMat S.A.
Chile

"Elyo Ravuna" <msdn (AT) nebim (DOT) com.tr> escribió en el mensaje
news:F1F91FC1-952A-4255-B367-B513072F1D39 (AT) microsoft (DOT) com...
another physical measure in the same tuple is not empty.
not matter which measure is selected as NON_EMPTY_BEHAVIOR.

I'm pretty sure it matters.

public @ the domain below
www.tomchester.net

"Elyo Ravuna" <msdn (AT) nebim (DOT) com.tr> wrote

another physical measure in the same tuple is not empty.
not matter which measure is selected as NON_EMPTY_BEHAVIOR.

It matters for the virtual cubes only - because in virtual cube it is not
true that all the measures are either NULL together or not NULL together.
For regular cubes it doesn't matter.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================