Report Portal

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.

Read more...

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.