Finding the Joins of a table

[system]

Hi All,

Is there a easy way to find how many joins are involved for a particular table? In other words, to how many tables a particular table is joined.The universe that I have involves lot of joins and tables. Hard to find out the Joins. I am interested in one single table.

Thanks…

---

JohnJustus (BOB member since 2007-06-25)

[system]

Hi,

Maybe the universe documenting utility could help you with this?

Document a universe using Excel and the Designer SDK

Author: [url=http://www.forumtopics.com/busobj/profile.php?mode=viewprofile&u=1343]Dwayne Hoffpauir, EDS[/url] Notes: The attached utility uses Excel and the Designer SDK to document a universe. Usage is rather straightforward. Click the "Document a Universe" button on the Control Sheet, log in, and select the specific universe. Information will be recorded on separate worksheets for:[list:5d8cd1056f]Database tables Database columns Joins Contexts Classes Objects Conditions[/list:u:5d8cd10…

Maybe not a direct help but perhaps the result of the utility is more readable than looking at the structure pane in Designer.

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Thanks Marek, I will check that… Appreciate it.

Thank You!

---

JohnJustus (BOB member since 2007-06-25)

[system]

Open your universe.
Activate “list mode”
Scroll down the list of tables and single-click the one of interest
Click the tiny triangle button on the border between tables and joins, it will filter the list of joins to only those related to the selected table

---

Dave Rathbun (BOB member since 2002-06-06)

[system]

Awesome Dave! Very useful. Proves that you have used Designer a lot . Ofcourse you are … but once again…

Thanks…

---

JohnJustus (BOB member since 2007-06-25)