Skip to Content
author's profile photo Former Member
Former Member

The link between InfoObjects in 2 entirely different Cubes

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 04, 2005 at 05:08 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.