Skip to Content
avatar image
Former Member

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.

Regards,

G.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 30, 2013 at 09:48 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 01, 2013 at 03:58 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 02, 2013 at 06:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded