Universe Design using external join strategy

[Former Member]

Hi,

I need to design a universe based on the joins in Database(Database Referential Integrity).

I am selecting the External join strategy(Database Constraints) and in the options "Database", I have selected retrieve the joins with the tables.

But when I insert a set of tables I do not see any joins, even when I select "Automatic Join detection", the designer is not able to detect any joins.

Is there a way to design a universe, where I can retrieve the joins based on the Database constrains(Primary Key and Foreign Key).

We are using BOE 3.1 and Oracle 10g database.

Please let me know you thoughts on this.

Thanks!

[Former Member · Accepted solution]

NR,

Is there a way to design a universe, where I can retrieve the joins based on the Database constrains(Primary Key and Foreign Key).

Though Designer has the feature to "seek and populate", I've never been a big fan of this capability. The best advice I've ever seen for your question is provided courtesy of Marek Chladny on the BoB forum. Please read his posting here: [http://www.forumtopics.com/busobj/viewtopic.php?t=85418]

Thanks,

John