[Mondrian] Using outer joins

[Julian Hyde]

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