Optimising NON EMPTY filtering in queries (by Chris Webb)

Recently, on a few engagements, I've found myself optimising queries which do non-empty filtering and thought I'd share some tips (apologies if some of these seem a bit obvious to the more advanced MDXers among you). This will probably turn into an ongoing series - I've got some other ideas that need a bit more testing/research before I write them up...

 

The first thing to do is to set the NON_EMPTY_BEHAVIOR property on your calculated members, if you can.