[Mondrian] Cubes based on Joins

Brian Vandenberg phantall at gmail.com
Fri Jul 24 15:06:31 EDT 2009


Julian,

  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.

-Brian

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.
>
> Julian
>
>  ------------------------------
> *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)
>
> -Brian
>
> 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.
>>
>> http://mondrian.pentaho.org/documentation/schema.php#Cube
>> "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.
>> http://forums.pentaho.org/showthread.php?t=47909&highlight=join+fact
>>
>> Is it still the case that Mondrian 3.1.1 does not yet support Cubes based
>> on a Join?
>>
>> Best Regards,
>> Jeffrey
>>
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>
>>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090724/6f0e29fc/attachment.html 


More information about the Mondrian mailing list