Calculated Members with ROOT(), Subcube and WHERE
When we build calculated members in our MDX queries we have to be careful not to make a few mistakes. The bahaviour of calculated members and scopes of the MDX expressions are well explained, but I would like to give a quick example of how mixing subcube expressions, WHERE clauses and calculated members can cause some headaches.
As an example I will use a Membership cube with a two dimensions, Gender and Age, and one measure - Person Count.
Tags: mdx