cancel
Showing results for 
Search instead for 
Did you mean: 

The link between InfoObjects in 2 entirely different Cubes

Former Member
0 Kudos

Hi Experts,

So I have identified all key figures and characteristics needed for a project. Found some of these in Cube 1 and Cube 2.

1.

If it is an HR project should all cubes come from HR?

2.

for a example I came across a number of VERSION TYPEs in different Cubes, can I use any of them, regardless of where I found the Cubes, as long as in business content?

3.Are the various key figures and characteristics from any 2 cubes Cube 1 and Cube 2 automatically linked together?

4.

Or, do we have to do anything like we do in databases where we need a primary need in two tables to link them?

Thanks in Advance

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Amanda,

no matter about object location...it's only a 'metadata' representation and not a real (physic) situation !

So, use the same object in several cubes with no problem !

There is no link between same KF in different cubes...fact tables (specific for every cube) are the only important thing to consider !

Hope now is clearer...

Bye,

Roberto

Former Member
0 Kudos

Hi,

thanks I understand the point that they can come from any CUBE, although that is surprising since some comes from SEM, HR, etc.

But most the important aspect of my question which you might have missed is this, if from

Cube1 I identified 0char1, 0char2, 0keyfig1, oKeyfig2

Cube2 I identified 0char3, 0char4, 0keyfig3, oKeyfig4

Cube3 I identified 0char5, 0char6, 0keyfig5, oKeyfig6

What relationship needs to exist in amongst

0char1, 0char2, 0keyfig1, oKeyfig2

0char3, 0char4, 0keyfig3, oKeyfig4

0char5, 0char6, 0keyfig5, oKeyfig6

in order to bring them into a single Cube?

I don’t think you can just take any characteristics and key figures and just place them in the dimensions in cube and in the fact table to form a new cube.

That is the core of my question when I asked

“Or, do we have to do anything like we do in databases where we need a primary need in two tables to link them?

Thanks in advance.

Former Member
0 Kudos

Hi Amanda,

Certainly, you need to link characteristics.

If, for example, you have costs KF and cost center char on one hand, and revenue KF and profit center char on the other one, you have to link cost and profit centers.

How different chars are to be linked depends on business logic.

Best regards,

Eugene

Former Member
0 Kudos

Hi Amanda,

<i>I don’t think you can just take any characteristics and key figures and just place them in the dimensions in cube and in the fact table to form a new cube.</i>

With reference to your above statment <b>yes</b> you can take any characteristics and key figures and group them in dimension/fact table in a Cube as long as it makes business sense.

What you see that some characteristics/key figure in SEM and other in HR, is merely a grouping where that particular characteristic is grouped by SAP.

From your example, you can also club 0char1, 0char2 with 0char3 and 0char5 to form Cube4. Wherein 0char1 in Cube1 will have no relation with 0char1 in Cube4.

To draw an analogy with tables, its as if 0Char1 corresponds to a field name xyz in the table and you can use the same field name xyz in another table without the two tables being related to each other.

Hope it helps.

Cheers

Anurag

Answers (0)