How to create Left outer Join while using SQL Cubes

[chakri99]

Hi

I have 3 files to join and get the data thru SQL Server Cubes.

File1(Primary) has 90 records while File 2 has 150 records
File1 and File2 can be joined by Feild1A = Field2A to get a set of 84 records when the Select condition is Feild2B = 'NDC' (one of the values for that field)

I would like to get all the 90 records from primary file File1 when I process the Cube with this Join instead of those 84 records only like in a left outer join.

Is there any tip to do this

Thaks
Chakra

 

[TomSark]

Couldn't you set up a virtual cube(s) that does this?

Tom

 

[chakri99]

I tried doing Virtual Cubes but the way the data looks is quite different.

The Join would correctly retrieve 90 records from Primary file as required by a left outer join. However It would show all 150 records for File2 when seen in detail instead of retrieving only 90 records.

Is there any other way

Chakra

 

[TomSark]

Do you have NULL values in the columns that you are joining?

Tom

 

[chakri99]

I do not have null values

Chakra