[Mondrian] Cubes based on Joins
phantall at gmail.com
Fri Jul 24 15:06:31 EDT 2009
Does this include Mondrian views? I'm getting some hideous exceptions in
schema workbench when I try to use a view for the fact table.
On Tue, Jul 7, 2009 at 6:21 PM, Julian Hyde <jhyde at pentaho.com> wrote:
> 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
>> "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
> Mondrian mailing list
> Mondrian at pentaho.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mondrian