|
Home > Archive > MS SQL Server OLAP > August 2005 > Left Join support in Cube Editor
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Left Join support in Cube Editor
|
|
| Default User 2005-08-28, 8:24 pm |
| 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@discussion
s.microsoft.com> wrote in message
news:EC8237CC-6E1F-4CFF-B6D7- E906654EB1D4@microso
ft.com...
> 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.
|
|
|
|
|