[Mondrian] Using outer joins
lucboudreau at gmail.com
Thu Oct 25 12:46:37 EDT 2012
I think he means when we use the Join elements to define snowflaked
dimension tables. In these cases, we use an inner join.
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.
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mondrian