MDX: Except
It’s a stock brokerage firm. They do some promotion campaigns and would like to know how many customer accounts in each campaign never bought or sold a certain stock. They would like to have this as a calculated measure in the cube.
Let’s do it in SQL first, then in MDX. This way we know what the result should be, so we can verify the MDX output.
So the article will flow like this:
Tags: mdx