[Mondrian] Cubes based on Joins
phantall at gmail.com
Tue Jul 7 13:19:16 EDT 2009
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
> "You can also use the <View><http://mondrian.pentaho.org/documentation/schema.php#XML_View>and
> <Join> <http://mondrian.pentaho.org/documentation/schema.php#XML_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...
More information about the Mondrian