NULL = 0?

Does everyone know that NULL is converted to 0 in Analysis Services before it is used in a comparison in MDX?

If you need to check to see if something is null, don't compare it to null, use the ISEMPTY() function.

Good Luck,



2 Responses to NULL = 0?

  1. Jules Bonnot says:

    Hi Mark i am getting this error which seems related to this behavior in MDX. You got any ideas how i might sort this out?
    Any help is greatly appreciated.
    Have a look at this-


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: