[Mondrian] Using outer joins

Nizar Mabroukeh nmabroukeh at crosscommercemedia.com
Thu Oct 25 14:10:14 EDT 2012


I meant to know about both. Thank you Julian and Luc

Nizar


On Thu, Oct 25, 2012 at 12:46 PM, Luc Boudreau <lucboudreau at gmail.com>wrote:

> I think he means when we use the Join elements to define snowflaked
> dimension tables. In these cases, we use an inner join.
>
> Luc
>
> On Thu, Oct 25, 2012 at 11:57 AM, Julian Hyde <jhyde at pentaho.com> wrote:
>
>> Completely untrue. Mondrian never uses outer joins of any kind (full,
>> left, right). (There are cases where in my opinion it should...)
>>
>> Turn on SQL tracing and you will see what Mondrian is doing.
>>
>> Julian
>>
>>
>> On Oct 25, 2012, at 7:27 AM, Nizar Mabroukeh <
>> nmabroukeh at crosscommercemedia.com> wrote:
>>
>> > Hi
>> >
>> > To my humble understanding, and please correct me if I am wrong,
>> Mondrian uses full outer joins to join dimension tables with fact tables in
>> a snowflake schema, and uses right outer joins to join dimension tables
>> with fact tables in a star schema.
>> > I am not sure if my understanding is completely right and I will
>> appreciate an assertion.
>> > If my understanding is completely right, then Mondrian will not require
>> full outer joins if a star schema is always enforced, and will never
>> require left outer joins.
>> >
>> > Any feedback is appreciated. Thanks.
>> >
>> > Nizar Mabroukeh
>> > _______________________________________________
>> > 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
>>
>
>
> _______________________________________________
> 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/20121025/140e4d92/attachment-0001.html 


More information about the Mondrian mailing list