A Few Notes on HAVING vs. FILTER

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:

Read more...