Skip to Content
Former Member
Mar 28, 2013 at 10:02 PM

Understand and writing SQL queries to fix Tables, joins, loops and conditions in BOBJ Universe


Dear Gurus,

We have a BOBJ 3.1 system for which Oracle is the datasource. It is a OLTP relational database. We already have the Enterprise Master data repository (EMDR) universe in BOBJ which gets the data (tables and columns) from Oracle. I am currently doing the 'Refresh Structure' to make sure the Universe gets the updated tables and columns from Oracle. Since it is a Relational database, I have to write SQL queries to fix the joins, loops and conditions.

I have only a basic understanding of SQL and have never written SQL queries before. Could you please let me know if there are any good documents/videos available to help me understand the concept of loops, joins and conditions and to write SQL queries in BOBJ universe for relational database?

Points will be awarded. Many thanks for your help.