How to join two ODS for query

[Babankumarja]

Dear All,

I have one scenario, where I need to add two ODS. One ODS containing Customer and Marketing Program information, wheras another ODS contains information about agreement , customer and marketing program. So we need one BW query report Which will show all the list of Customer assigned with Marketing program and shows its corresponding agreement value if assigned and not assigned.

I am not able to get this result through Multi-provider as it is showing only those marketing prgm,whose having agreement. Please suggest what need to do?

[Former Member · Accepted solution]

Hi Baban,

Best way to do this is using Multiprovider or InfoSet with Proper Joins.

Other wise move Customer and Marketing Program information DSO to a Cube and in transformation do lookup to agreement , customer and marketing program and populate same in Cube against those records.

Take care about Keys from both DSO's so that you will not mis anything.

Regards,
Ganesh