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
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