Left Join ?

#1

How I do a LEFT JOIN ?
If my database has bas links I do not get records when I do analysis because
INNER JOIN is on.

Thanks
D.E.

#2

Analysis Manager supports only inner join. If you need left join, you can
define a view (i suppose you are using SQL server for the source database)
as the fact table.

Francesco Anti

"D.E." <dimitris (AT) add (DOT) gr> wrote

Quote:

How I do a LEFT JOIN ?
If my database has bas links I do not get records when I do analysis
because
INNER JOIN is on.

Thanks
D.E.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Left Join ?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Left Join ? - 06-21-2005 , 02:18 AM

Re: Left Join ? - 06-21-2005 , 10:39 AM