Combining Cubes

[Former Member]

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

[Former Member]

I don't know the cubes are you using. In base to your planned logic, you have to derive wbs element from network/activity, i supose that network and activity are in one cube and wbs in the other one, aren't they? then you need to add wbs element to the cube, for joining the cubes in a multicube, and derivate it from network/activity in the update rules.

[Former Member]

Here is the two cubes,

CUBE 1 - 0CATS_C01 - Time sheets Approved

0NETWORK Network

0R_ACTIVITY Activity Number

ZWORKITEM Work items (Customized field)

CUBE 2 - 0PS_C04 Project Systems

0NETWORK Network

0PROFIT_CTR Profit Center

0PROJECT Project Definition

0ACTIVITY Activity Number

0WBS_ELEMT Work Breakdown Structure Element

0CO_AREA Controlling area

0RECV_NETW Receiver network

As per you suggestion, can i add the WBS element in CUBE 1 and update that through update rules..

I am not familiar/clear with the following point.

"derivate it from network/activity in the update rules."

Once i add the wbs element to the CUBE 1, could you tell me the steps to proceed...

Thank you Oscar...I assigned the points

[Former Member]

If you want to derivate wbs element from network and activity, it must exist any logic for having network and activity deduce wbs element. That logic should be applied in update rules.

[Former Member]

Add the charactics in the cubes and derivate it into their update rules in order to have the conection between both cubes, but you had to reload cubes.

[Former Member]

Hi there,

Could you please explain bit more.

Thanks, Kumar

[Former Member]

You don't have common characteristics to use a multicube, then add the characteristics to your cubes in order of having that common characteristics for using a multicube. Derivate them in the update rules of corresponding cube, but for populating them you will have to reload

[Former Member]

...or you could create export data sources of the two cubes and create a new data target (info cube) containg the fields you'd like to see (provided that the data is on the same level (for example document item level) in both cubes)...

Hope it helps,

Fredrik

[Former Member]

Hi Oscar,

Thanks for your information and patience. I still have couple of questions, please explain.

1)Do you want me to identify the common characteristics and add missing characteristics to both the cubes? Right now the PS cube contains huge volume of data.

2)How could i derivate them in the update rules?

Thank You Oscar.

[Former Member]

Hi Fredrick,

Thanks for your input, I am just looking for a solution without going for a new data target, if not finally i should go with your solution.

Thank You