paul.farnell (1/23/2015)
Brilliant, that is really good . . . Next question, how do you make Report Builder / SSRS behave in the same manner ?
There should be a similar setting somewhere.
You can specify it in the MDX, that's certain. (by default the MDX designer add NON EMPTY to the query)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP