Open Orders and COPA Cube

Hi,

I have a specific requirement, where we want to add open orders from sales to the existing COPA cube and also we want Existing Open order/sales pipeline reports in SAP to be moved into BI.

Can any one help me on how to go about this and what should be the best apporoach to achieve this task.

Any help technically and functionally will be very helpful

Regards

Vishwanath