Hi again,<br><br>I don't mind that this is not supported, but the public documentation should be updated to reflect this fact.<br><br>See <a href="http://mondrian.pentaho.org/documentation/schema.php#Cube" target="_blank">http://mondrian.pentaho.org/documentation/schema.php#Cube</a>, especially the last line before the section on measures.<br>
<br>-Jeffrey<br><br><div class="gmail_quote">2009/7/7 Julian Hyde <span dir="ltr"><<a href="mailto:jhyde@pentaho.com">jhyde@pentaho.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div><span><font color="#000080" face="Lucida Sans" size="2">Brian is correct; we don't support using a Join as fact
table.</font></span></div>
<div><span><font color="#000080" face="Lucida Sans" size="2"></font></span> </div>
<div><span><font color="#000080" face="Lucida Sans" size="2">See <a href="http://jira.pentaho.com/browse/MONDRIAN-231" target="_blank"><font face="Times New Roman" size="3">http://jira.pentaho.com/browse/MONDRIAN-231</font></a>.</font></span></div>
<div><span><font color="#000080" face="Lucida Sans" size="2"></font></span> </div>
<div><span><font color="#000080" face="Lucida Sans" size="2">Julian</font></span></div><br>
<blockquote style="border-left: 2px solid rgb(0, 0, 128); padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b> <a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>
[mailto:<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>] <b>On Behalf Of </b>Brian
Vandenberg<br><b>Sent:</b> Tuesday, July 07, 2009 10:19 AM<br><b>To:</b>
Mondrian developer mailing list<br><b>Subject:</b> Re: [Mondrian] Cubes based
on Joins<br></font><br></div><div><div></div><div class="h5">
<div></div> Check the forums for more details, there was a post from me
on this about 8-12 months ago. I don't remember specifics, and I
sincerely hope I posted the results of my findings, but back then, and I
imagine now, you could not use joins -- the documentation was
wrong.<br><br> To get around this I experimented with using views, and
generating a bastardized materialized view (bastardized in that mysql doesn't
support them, so it was a static view in table form)<br><br>-Brian<br><br>
<div class="gmail_quote">On Tue, Jul 7, 2009 at 9:38 AM, Jeffrey Mo <span dir="ltr"><<a href="mailto:jeffrey@sqlpower.ca" target="_blank">jeffrey@sqlpower.ca</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hello
everyone,<br><br>In the Mondrian on-line documentation for designing a
Mondrian schema, there is a statement that suggests that you can use a Join
as a basis for a Cube.<br><br><a href="http://mondrian.pentaho.org/documentation/schema.php#Cube" target="_blank">http://mondrian.pentaho.org/documentation/schema.php#Cube</a><br>"You
can also use the <code><a href="http://mondrian.pentaho.org/documentation/schema.php#XML_View" target="_blank"><View></a></code> and <code><a href="http://mondrian.pentaho.org/documentation/schema.php#XML_Join" target="_blank"><Join></a></code> constructs to build more complicated
SQL statements."<br><br>However, when I try using a Mondrian Schema
definition containing a Cube based on a Join on with Mondrian 3.1.1, I get
the following error:<br><br>Exception : Schema file parsing failed.In
Schema: In Cube: element <Join> is not of expected type
mondrian.gui.MondrianGuiDef$Relation<br>org.eigenbase.xom.XOMException: In
Schema: In Cube: element <Join> is not of expected type
mondrian.gui.MondrianGuiDef$Relation<br><br>A bit of searching in the
Pentaho forum turned up this post from May 2006, indicating that Cubes based
on Joins had not been implemented at that time.<br><a href="http://forums.pentaho.org/showthread.php?t=47909&highlight=join+fact" target="_blank">http://forums.pentaho.org/showthread.php?t=47909&highlight=join+fact</a><br>
<br>Is
it still the case that Mondrian 3.1.1 does not yet support Cubes based on a
Join?<br><br>Best Regards,<br><font color="#888888">Jeffrey<br></font><br>_______________________________________________<br>Mondrian
mailing list<br><a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br><a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br></div></div></blockquote></div>
<br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br>