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,

Mark

Advertisements

2 Responses to NULL = 0?

  1. Jules Bonnot says:

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=570739&SiteID=1&mode=1

    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-
    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=570739&SiteID=1&mode=1

    Thanks

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: