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🙏
@bobigeeks19375 ай бұрын
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.
@ayaanrockstar69955 ай бұрын
@@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.
@mahdisaleh571211 ай бұрын
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
@nadezdagodmane23112 жыл бұрын
Thank you for so detailed explanations!
@jagadeeshmummaneni71932 жыл бұрын
Hi admin, please continue to do this series
@ishukumar20412 жыл бұрын
Bo is now done and dusted
@Gunjan23933 жыл бұрын
thanks
@VinodKumar-cp5bt4 жыл бұрын
Great Explanation and it is Useful...!!! Index awareness took a bit longer.
@raviprashant75 жыл бұрын
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
@bobigeeks19375 жыл бұрын
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.
@prashantpatil41005 жыл бұрын
Very Nice explanation :) ...keep up the good work.
@romidey9836 жыл бұрын
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..
@indranisandur96446 жыл бұрын
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?
@bobigeeks19376 жыл бұрын
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.
@nishantkumar90596 жыл бұрын
Thanks friend Well explained...
@venugopalreddy54116 жыл бұрын
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]
@raheelasghar43876 жыл бұрын
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?
@venkateshboga48707 жыл бұрын
Thank a lot Bro.. Very well explained.. 👍👍
@lalithasekar77886 жыл бұрын
Hi, could you explain what will happen if loop with all tables with one to one Cardinality
@bobigeeks19376 жыл бұрын
Hi, I am not able to create a loop with all table in 1 to 1 relationship. Could you please explain with an example.
@bobigeeks19376 жыл бұрын
felling good to hear that ...Thank You
@imranbalogun47937 жыл бұрын
Nice! Can you please send me your email here [email protected]. I have some questions. Thanks
@bobigeeks19376 жыл бұрын
Done ! Please check your Mail
@MrIrrepressible7 жыл бұрын
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)
@kuntal887 жыл бұрын
thanks brother..:)
@bobigeeks19376 жыл бұрын
Glad to Help You :)
@anshumansharma63367 жыл бұрын
nicely explained
@bobigeeks19376 жыл бұрын
Thank you :)
@anirbansengupta22317 жыл бұрын
This video helped me to get more insight.. great (y)