Multicube: crm + r/3?

[Former Member]

Hi Experts,

We have two cubes:

1. cube for R/3 billing data

2. cube for CRM chargeback structure data.

We have a requirements based on these two cubes.

In the report,we want to display Sales Representative wise 'Hospital Name and code' then sales figure(column). The Hospital name and code data are coming from CRM but not from R/3. The user is saying that take these data from CRM system.

I guess we should have these data in r/3 cube also.

Can some body help me to solve this issue.

Thanks in advance

Mahantesh

[former_member671571]

You can have look up on ODS Object(if exists for CRM data) and get the data into the InfoCube. So that you can report on both data.

You can try Multiprovider but you can show 'Hospital Name and code' as display attributes.