MDX ratio of "current parent" issue

Written by Darren Gosbell on 26 July 2008. Posted in MDX

Every now and then on the SSAS MSDN forum, the issue of doing a generic "ratio to parent" calculation comes up. Unfortunately there are a number of problems with the premise of giving users a generic "ratio to parent" measure.

The first is that the concept of "parent", by definition, requires a hierarchy and SSAS 2005 supports multiple hierarchies.

Consider this query:

MDX ratio of "current parent" issue

Similar Articles