How do I convince the cube editor to perform a left join (instead of the
standard inner join). I have used views in some instances, but that's not
conducive to having good shared dimenions.

Any ideas appreciated.

left join is not supported.

you have to create a view which return a value instead-iof a null value. and
use this view as the fact table

like:
select tbla.col1, tbla.col2, isnull(tblB.col3, -1) as NewCol
from table1 tbla left join table2 tblB
on tbla.col4 = tblB.col1

then make sure that your dimension linked to the NewCol contain a -1 value.
(which could be an unknown member in the dimension)


"Default User" <anonymous (AT) discussions (DOT) microsoft.com> wrote