Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. Elementary MDX Techniques > Using NON_EMPTY_BEHAVIOR

Using NON_EMPTY_BEHAVIOR

In SSAS 2005, the NON_EMPTY_BEHAVIOR property (NEB for short) was used for optimization of calculated members and cells as well as MDX script assignments. The optimization was done by indicating under which circumstances the expression can be ignored because the dependent expression returns null and vice versa. The rules for proper usage were either unknown or a bit too complex for many, so there was a lot of a misuse and incorrect results.

The situation changed with SSAS 2008. The new engine handled many scenarios automatically, without the NEB specified. It has been said that NEB is required only in a small number of situations where the expression is very complex or dense. In all others it should be left out.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint