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

[Former Member]

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.

Regards,

G.

[abkshatriya · Accepted solution]

Hi Goutham,

Please check below link...

Link belongs to IDT but in UDT and IDT Joins and Loops are handled in same way..

http://scn.sap.com/docs/DOC-8461

Thanks

[Former Member · Accepted solution]

Thanks AB!

G.

[Sujit]

Goutham In addition you can visit the below link for more information on Loops

http://businessobjectsforum.blogspot.in/2008/07/resolving-loops-in-universe.html

Sujit

[Former Member]

Hi Goutham,

Chapter No:4 from BO XI 3.1-Universe Designer Guide will be a best fit to answer all your requirements.

https://help.sap.com/businessobject/product_guides/boexir31/en/xi31_designer_en.pdf

Apart from that, the basic SQL concepts remain the same so you can refer any online Oracle SQL tutorial for the same.You would need understanding of Oracle-specific SQL functions that can help in creating user-defined objects at the Universe end.

Thanks,

Prathamesh