ODS reporting query from multiple info sources

[boyle]

Hi,

I have created an ODS using multiple info sources (billing, deliveries and orders , at header and line item detail) and have a requirement to report on information from say the billing and orders info sources. I have taken care when setting up the key fields to ensure that the info objects anf field names are the same where appropriate as I understand that this is very important for the production of reports, from 2 or more infosources.

However when I produce a report I cannot obtain information from 2 or more infosources. the resultant figures report as 'unassigned', and only the information from one info source will be recorded.

Is the ODS the correct platform to use to report when using 2 or more infosources?
Any suggestions