[Mondrian] RE: Same hierarchy on different axis

Brian Vandenberg phantall at gmail.com
Mon Jul 20 10:37:40 EDT 2009


  I agree 100% on this.  Just being able to use multiple (unique)
hierarchies across multiple axes would be very convenient.

-Brian

On Fri, Jul 17, 2009 at 12:37 PM, Julian Hyde <jhyde at pentaho.com> wrote:

>  I don't think it makes sense to allow the same hierarchy on two different
> axes. What does make sense is what AS2005 does. They have 'attribute
> hierarchies' which look a lot like levels except they can be used
> independently. But you still have old-fashioned hierarchies with multiple
> levels. And typically, an attribute that is used as a level would also have
> its own attribute hierarchy.
>
> E.g. the customer dimension might have a customer hierarchy, a state
> attribute hierarchy, a city attribute hierarchy, and a gender attribute
> hierarchy. You can have customer hierarchy on one axis, and state on
> another. But you can't have the customer hierarchy on two different axes.
>
> Hope that makes sense. If anyone has a good reference to attribute
> hierarchies, please share it. 'MDX Solutions', by Spofford et al., explains
> it well, but I can't hyperlink a book sitting on my desk. :)
>
> Julian
>
> PS Sorry to hear about your motherboard.
>
>  ------------------------------
> *From:* Pedro Alves [mailto:pedro.alves at webdetails.pt]
> *Sent:* Friday, July 17, 2009 7:56 AM
> *To:* jhyde at pentaho.com
> *Subject:* Same hierarchy on different axis
>
>
> Hey.
>
> Sorry to reply to you directly; I was replying to the ML when my server's
> motherboard crashed, and now I have a nasty problem to solve. I will when I
> get it back, but wanted to reply to you since you told you might do some
> work on that issue
>
>
> You said that it will give error if members from the same hierarchy are
> used in different axis. Can this NOT happen?
> Better than explain, I'll show you why it's important for me:
>
> I attached 3 pictures of the designer I'm working in. I would like users to
> make the combinations they want. In that example, the user defined 2
> selectors, one for the year and another for the market; Now he wants to do 2
> charts - clients and countries (countries are in the same dimension as
> markets, just a different level).
>
> It would make my job much easier if I could just abstract what's displayed
> from what's being filtered; output.png shows the final result, of course,
> reflects a mondrian exception related to the same hierarchy being in 2 axis.
>
> IMHO it should be up to the users the responsibility to make sure he
> doesn't use weird combinations (like select [Countries].[Portugal] on 0,
> [Countries].[USA] on 1)
>
>
> Thanks
>
> --
> Pedro Alves                             pedro.alves at webdetails.pt
> WebDetails Consulting                           www.webdetails.pt
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090720/1c7323ad/attachment.html 


More information about the Mondrian mailing list