BO Loop and its Resolution

This video describe what is join in BO ? How it cause problem ? and what are the resolution method?
It explain the problem with scenario and Universe examples
it also covered :
Alias Method
Context Method
Shortcut Join

[@mahdisaleh5712]

Thanks so much. You explained the concepts very well.

[@chkanthikiran]

Nice Explaination dude, completely covered loops, can You do a lecuture on the ambigious query as well from report perspective

[@nadezdagodmane2311]

Thank you for so detailed explanations!

[@venkateshboga4870]

Thank a lot Bro.. Very well explained.. 👍👍

[@lalithasekar7788]

Hi, could you explain what will happen if loop with all tables with one to one Cardinality

[@bobigeeks1937]

Hi, I am not able to create a loop with all table in 1 to 1 relationship. Could you please explain with an example.

[@bobigeeks1937]

felling good to hear that ...Thank You

[@prashantpatil4100]

Very Nice explanation :) ...keep up the good work.

[@anshumansharma6336]

nicely explained

[@bobigeeks1937]

Thank you :)

[@ayaanrockstar6995]

Please correct me if I m wrong: Looking at the loop diagram and the arrow pattern, I can see that: Table Maker to Table Model has One to many relation . Table Model to Table Rental_Model has One to many relation. so we can't create context including Table maker and Table Model because, context can be created using Many to one relations. We should create context starting from Table Rental_Model to Table Country_Region But u are saying here Maker to Model is "Many to one" and Model to Rental_Model is also Many to one. Please clear my doubt🙏

[@bobigeeks1937]

See it from source (Country table) to destination (Model Rental Table), Context is kind of path to indicate the SQL engine to which all table need to include to make the join . if you start from end seachfor Many to one, You will find Table Rental model-> model -> maker -> country maker all are in same relationship so context is possible.

[@ayaanrockstar6995]

@@bobigeeks1937 Thanks a lot for clarification 🙏 One question can u plz help me with and if u have any video link for the same: Is it possible to use existing Plsql Functions and Packages in BO Universe, Actually I need to create a BO universe in 4.2 version and want yo use some existing Plsql packages and functions in my BO universe.

[@indranisandur9644]

Nice explanation. One question, if we do not have any loop in universe but we are having multiple fact tables then also do we have to define contexts?

[@bobigeeks1937]

Yes its a best practice to create context and avoid isolated joins. In your case, if loops are not there it will not affect but its recommended to do that.

[@kuntal88]

thanks brother..:)

[@bobigeeks1937]

Glad to Help You :)

[@raviprashant7]

Even after creating a context which covers both the path, I get a message that "The loop can be resolved with an alias". Does that mean the loop has not been resolved or is the universe just suggesting that the loop can also be resolved with an alias. Please can you help me with this point. Thanks in advance

[@bobigeeks1937]

Loop is resolved or not -you can check that my Integrity check. You cannot publish the universe with loop resolve. So if you were able to do then it may be you resolved the issue but not by the optimal way.