<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18783"></HEAD>
<BODY bgColor=#ffffff text=#000000>
<DIV><SPAN class=621503118-17072009><FONT color=#000080 size=2
face="Lucida Sans">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.</FONT></SPAN></DIV>
<DIV><SPAN class=621503118-17072009><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=621503118-17072009><FONT color=#000080 size=2
face="Lucida Sans">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.</FONT></SPAN></DIV>
<DIV><SPAN class=621503118-17072009><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=621503118-17072009><FONT color=#000080 size=2
face="Lucida Sans">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.
:)</FONT></SPAN></DIV>
<DIV><SPAN class=621503118-17072009><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=621503118-17072009><FONT color=#000080 size=2
face="Lucida Sans">Julian</FONT></SPAN></DIV>
<DIV><SPAN class=621503118-17072009><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=621503118-17072009><FONT color=#000080 size=2
face="Lucida Sans">PS Sorry to hear about your
motherboard.</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #000080 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> Pedro Alves
[mailto:pedro.alves@webdetails.pt] <BR><B>Sent:</B> Friday, July 17, 2009 7:56
AM<BR><B>To:</B> jhyde@pentaho.com<BR><B>Subject:</B> Same hierarchy on
different axis<BR></FONT><BR></DIV>
<DIV></DIV><FONT face="DejaVu Sans"><BR>Hey.<BR><BR>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<BR><BR><BR>You said that it will give error if members from the same
hierarchy are used in different axis. Can this NOT happen?<BR>Better than
explain, I'll show you why it's important for me:<BR><BR>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).<BR><BR>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.<BR><BR>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)<BR><BR><BR>Thanks<BR><BR></FONT><PRE class=moz-signature cols="72">--
Pedro Alves <A class=moz-txt-link-abbreviated href="mailto:pedro.alves@webdetails.pt">pedro.alves@webdetails.pt</A>
WebDetails Consulting <A class=moz-txt-link-abbreviated href="http://www.webdetails.pt">www.webdetails.pt</A>
</PRE></BLOCKQUOTE></BODY></HTML>