[Mondrian] [MDX] How to find the current hierarchy

Pedro Alves pmgalves at gmail.com
Thu Dec 22 13:51:50 EST 2011

That's exactly what I want. On this case I'm interested in defining a 
measure that says the percentage of that element according to the 
total. I guess I'll have to rethink this, thanks

On Thu 22 Dec 2011 06:41:43 PM WET, Julian Hyde wrote:
> On Dec 22, 2011, at 10:15 AM, Pedro Alves wrote:
>> So - I'm screwed?
> I guess... if you want to put it that way...
> To put it more charitably. If you want a concept of "current hierarchy", it doesn't exist in MDX, so you will need to add it in the UI model.
> Remember, hierarchies are intended not just for the case where Time has hierarchies Monthly and Weekly, and most people only want one of these on the screen. We also need to the case where Gender, Marital Status, Geography, City, Age are all hierarchies in the Customer dimension, and people would often want to display more than one of these.
> Julian
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian

More information about the Mondrian mailing list