i have to generate a report like this
there r three columns
(plant) (no of employees) (sales revenue for the plant/employee)
i got headcount cube where i get the plant wise no of employees
and i got sales cube where i will get sales revenue based on the sales office.
sales office in sales cube is same as plant in headcount cube.
here i want to create a multiprovider but my problem is how can i map the sales office with plant .
pls help he how to go about this scenario .
Thanks in adcance.