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