[Mondrian] RE: Same hierarchy on different axis
Brian Vandenberg
phantall at gmail.com
Mon Jul 20 14:59:46 EDT 2009
Ah, I should probably clarify there. I skimmed what Julian wrote, sorry.
It would be nice if you could have the same hierarchy on multiple axes, I
was trying to express my enthusiasm toward the change Julian mentioned.
If we could get both, all the better.
-Brian
On Mon, Jul 20, 2009 at 12:52 PM, Pedro Alves <pmgalves at gmail.com> wrote:
>
> Just to check - Brian, do you agree it does *not* make sense to allow the
> same hierarchy in multiple axis? :(
>
>
> On 07/20/2009 03:37 PM, Brian Vandenberg wrote:
>
>> 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
>> <mailto: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
>> <mailto:pedro.alves at webdetails.pt>]
>> *Sent:* Friday, July 17, 2009 7:56 AM
>> *To:* jhyde at pentaho.com <mailto: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 Alvespedro.alves at webdetails.pt <mailto:
>> pedro.alves at webdetails.pt>
>> WebDetails Consultingwww.webdetails.pt <http://www.webdetails.pt>
>>
>>
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org <mailto:Mondrian at pentaho.org>
>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>
>
> _______________________________________________
> 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/d51e506c/attachment.html
More information about the Mondrian
mailing list