Left outer join... Universe table & Excel data...

The common dimension if of Char type.
When i display both the dimensions in a table they bothe show the exact same value, though the Excel file does not have as many rows as the table does.
Shouldnt this be a full outer join and show ‘NULL’ if the corresponding value doent exist in the other data provider.

I looked at this…

Thanks.


queryanalyzer (BOB member since 2005-08-28)