MDX Scope with an If Then Exception or Filter
The scope statement in MDX is great for applying calculations to a certain area of a cube, also called a subcube. Dustin Ryan wrote a great article on the scope statement here. The issue I am going to cover will be using the scope statement when you only want to cover all but one member of a dimension.
The normal scope statement would be:
Tags: mdx