[Mondrian] Using outer joins

[Luc Boudreau]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20121025/eb66e559/attachment.html