|A Few Notes on HAVING vs. FILTER|
|Written by Reed Jacobson|
|Friday, 10 September 2010 00:11|
The HAVING clause in MDX 2005+ is little-known (and those who do know about it know that it is poorly documented). I did a few experiments today that might be useful for some.
Random Sample Query That Uses FILTER
I'll start with a sample query that uses Filter—specifically as an intermediate step in a calculated member. I was curious whether I could use HAVING to get the same result: