Skip to Content
avatar image
Former Member

SAP Power Designer (LDM): Identify relationships between entities

How to identify potential relationships between entities across different subject areas in the same model
I've a scenario where I need to find relationship between Entity A and Entity B

Subject Area 1 - EntityA.a1 = EntityB.b1
Subject Area 2 - EntityA.a1 = EntityC.c1
EntityC.c2 = EntityB.b2

and so on..

is there a way that SAP Power Designer enables to track these in the form of report instead of manually identifying them in the diagrams ?

Reference: I've worked on SAP BusinessObjects and Universe Designer/IDT has a way to find relationship between entities (If multiple paths are involved between 2 entities, it displays those too in the form of contexts)
I'm looking for a similar funtionality in SAP power designer too. Any insight or hints would be appreciated.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 19, 2017 at 12:26 PM

    Hello Shilpa

    When you edit an entity, click on the Dependencies tab (click the 'More' button if you need to), and you'll see a list of all the relationships it participates in.

    When you talk about having entities in "subject areas" (terminology from ERwin), I assume you mean that you have entities owned by "Packages", which is not a problem, you'll be pleased to hear, though it does have an impact on what happens when you select an item on the Model menu.

    The Model menu allows you to access lists of objects known to the current package - in this discussion, the model itself is just the top-level package. So, if the diagram you're currently looking at is within a package, the Model menu will give you access to a list of relationships known to the package; you can extend the list to include additional relationships known to the sub-packages as well, if you have any.

    To access a list of all the relationships in a model, you have a few options:

    • open a model-level diagram, and use the Model menu - make sure you click on "include sub-packages" on the toolbar, so you include the relationships owned by the packages
    • right-click the model name in the Browser, select list of, then relationships
    • create a List Report in the model - choose Relationship as the object type, and include the option "include sub-packages"
    • create a Report
    By the way, do you really need to use Packages? If your model is small enough, you could just have a series of diagrams in the model, you could extend the model to include a "Subject Area" property on entities, or add "Subject Area" as a new type of object that you link to entities.
    Add comment
    10|10000 characters needed characters exceeded