BO Loop and its Resolution
28:00
7 жыл бұрын
@Function in BO
26:54
7 жыл бұрын
Joins In SAP BO
17:41
7 жыл бұрын
Connection in SAP BO
6:15
7 жыл бұрын
Пікірлер
@shovikrijudas
@shovikrijudas 12 күн бұрын
Sanjay Sir please upload new videos
@shovikrijudas
@shovikrijudas 12 күн бұрын
Hi
@shovikrijudas
@shovikrijudas 12 күн бұрын
Hi
@ayaanrockstar6995
@ayaanrockstar6995 5 ай бұрын
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
@bobigeeks1937 5 ай бұрын
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
@ayaanrockstar6995 5 ай бұрын
@@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.
@mahdisaleh5712
@mahdisaleh5712 11 ай бұрын
Thanks so much. You explained the concepts very well.
@chkanthikiran
@chkanthikiran Жыл бұрын
Nice Explaination dude, completely covered loops, can You do a lecuture on the ambigious query as well from report perspective
@nadezdagodmane2311
@nadezdagodmane2311 2 жыл бұрын
Thank you for so detailed explanations!
@jagadeeshmummaneni7193
@jagadeeshmummaneni7193 2 жыл бұрын
Hi admin, please continue to do this series
@ishukumar2041
@ishukumar2041 2 жыл бұрын
Bo is now done and dusted
@Gunjan2393
@Gunjan2393 3 жыл бұрын
thanks
@VinodKumar-cp5bt
@VinodKumar-cp5bt 4 жыл бұрын
Great Explanation and it is Useful...!!! Index awareness took a bit longer.
@raviprashant7
@raviprashant7 5 жыл бұрын
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
@bobigeeks1937 5 жыл бұрын
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.
@prashantpatil4100
@prashantpatil4100 5 жыл бұрын
Very Nice explanation :) ...keep up the good work.
@romidey983
@romidey983 6 жыл бұрын
Hi Would you please help me to add dynamic date in the default value (7th parameter) in the @prompt function. For e.g. to show the default value as 1st day of the current year, last day of the current month like that. Thanks in advance..
@indranisandur9644
@indranisandur9644 6 жыл бұрын
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
@bobigeeks1937 6 жыл бұрын
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.
@nishantkumar9059
@nishantkumar9059 6 жыл бұрын
Thanks friend Well explained...
@venugopalreddy5411
@venugopalreddy5411 6 жыл бұрын
Hello Sanjay, Thanks for sharing your knowledge and it is very easy to understand the way you are presenting and here we can able to understand the usage of @aggregate_aware function but not practically Here i want to know how to implement the @aggregate_aware function in universe using IDT....i am facing the so many issues on the same topic every day...could you please give me some more examples it's really help full for me it saves my life my email: [email protected]
@raheelasghar4387
@raheelasghar4387 6 жыл бұрын
Hi Sanjay. Thanks for sharing your knowledge here. I see that in your videos you are using UDT. I wanted to know if you have created any videos for IDT?
@venkateshboga4870
@venkateshboga4870 7 жыл бұрын
Thank a lot Bro.. Very well explained.. 👍👍
@lalithasekar7788
@lalithasekar7788 6 жыл бұрын
Hi, could you explain what will happen if loop with all tables with one to one Cardinality
@bobigeeks1937
@bobigeeks1937 6 жыл бұрын
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
@bobigeeks1937 6 жыл бұрын
felling good to hear that ...Thank You
@imranbalogun4793
@imranbalogun4793 7 жыл бұрын
Nice! Can you please send me your email here [email protected]. I have some questions. Thanks
@bobigeeks1937
@bobigeeks1937 6 жыл бұрын
Done ! Please check your Mail
@MrIrrepressible
@MrIrrepressible 7 жыл бұрын
Please help me with my prompt, @Prompt('Enter Period as 99 (or use default text for previous month)','N', 'List of Valid Periods' ,Multi,persistent,{99}) = 99 List of Valid Perdiods is my LOV object but I get this error: Error parsing the expression: The following parameter is wrong: List of Valid Periods The following parameter is wrong: List of Valid Periods . (IES 01028)
@kuntal88
@kuntal88 7 жыл бұрын
thanks brother..:)
@bobigeeks1937
@bobigeeks1937 6 жыл бұрын
Glad to Help You :)
@anshumansharma6336
@anshumansharma6336 7 жыл бұрын
nicely explained
@bobigeeks1937
@bobigeeks1937 6 жыл бұрын
Thank you :)
@anirbansengupta2231
@anirbansengupta2231 7 жыл бұрын
This video helped me to get more insight.. great (y)
@kuntal88
@kuntal88 7 жыл бұрын
thanks awesome video