Skip to Content
0
Former Member
Jun 09, 2006 at 09:29 AM

Combining Cubes

10 Views

Hi Gurus,

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.

0NETWORK Network

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

Planned Logic

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..

Thank you,

Kumar