| 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 FILTERI'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:
|
