Hi All

In Analysis Server the Relation between the Fact table and Dimension Table is taking the link as inner join by default. Is there any way to change the joins option .

Thanks
Vasu

It's not possible to change the join criteria from an inner join to an outer join. If you want to do this, what you'll need to do is create views using outer joins and then use those views as the source for the cubes/dimensions.

Sean


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"vasu" <vasu (AT) stcroixsystems (DOT) com> wrote

Hi All

In Analysis Server the Relation between the Fact table and Dimension Table is taking the link as inner join by default. Is there any way to change the joins option .

Thanks
Vasu