I need to combine the cubes 0CATS_C01 & 0PS_C04 to generate and present reports by profit center, project definition and customer.
0CATS_C01 - Time sheets Approved
0PS_C04 - Project Systems
We can't combine using multiproviders because, don't have common characteristics. These are the fields i am expecting to be displayed in the report.
0PROFIT_CTR Profit Center
0PROJECT Project Definition
0R_ACTIVITY Activity Number
0WBS_ELEMT Work Breakdown Structure Element
ZWORKITEM Work items (Customized field)
0CO_AREA Controlling area
0RECV_NETW Receiver network
The logic would need to use the network/activity to derive the wbs element,the customer user field is on the wbs, the wbs element can be used to determine the project definition, and then the profit center would be determined from the project definition.
IT WOULD BE GREAT, YOU PEOPLE CAN PROVIDE SOME CLUES (As a starting point) TO GET THE SOLUTION..