[Mondrian] Cubes based on Joins

Julian Hyde jhyde at pentaho.com
Tue Jul 7 14:21:10 EDT 2009

Brian is correct; we don't support using a Join as fact table.
See  <http://jira.pentaho.com/browse/MONDRIAN-231>


From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Brian Vandenberg
Sent: Tuesday, July 07, 2009 10:19 AM
To: Mondrian developer mailing list
Subject: Re: [Mondrian] Cubes based on Joins

  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.

  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)


On Tue, Jul 7, 2009 at 9:38 AM, Jeffrey Mo <jeffrey at sqlpower.ca> wrote:

Hello everyone,

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.

"You can also use the
<http://mondrian.pentaho.org/documentation/schema.php#XML_View> <View> and
<http://mondrian.pentaho.org/documentation/schema.php#XML_Join> <Join>
constructs to build more complicated SQL statements."

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:

Exception  : Schema file parsing failed.In Schema: In Cube: element <Join>
is not of expected type mondrian.gui.MondrianGuiDef$Relation
org.eigenbase.xom.XOMException: In Schema: In Cube: element <Join> is not of
expected type mondrian.gui.MondrianGuiDef$Relation

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.

Is it still the case that Mondrian 3.1.1 does not yet support Cubes based on
a Join?

Best Regards,

Mondrian mailing list
Mondrian at pentaho.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090707/79d46b95/attachment.html 

More information about the Mondrian mailing list