I have a Multiprovider created joining 2 ODS's. One ODS has 5 key fields and the second one has 3 key fields. The 3 in the second one is common to 3 in the first. Can we join 2 ODS's with different number of key fields? We are having incorrect data shown in the reports for example the ODS which has just 3 key fields doesn't display certain characteristics which are unique to itself in the reports.
Any idea or suggestion would be greatly appreciated.
Actually none of the data in the ODS with 3 key fields are shown in the report. Is there any criteria to choose while creating a multiprovider and if so what am I missing?