- 5
- 25 785
BOBI Geeks
เข้าร่วมเมื่อ 16 เม.ย. 2017
Hello Everyone, My Name is Sanjay Guha, I am working as BO Consultant in IT Product Based Company. I am SAP Certified in BI.
There is very few content in BO present in Internet/Market at free of Cost. This channel is help you out with SAP BOBI Domain.You will get full information about Architecture,Functional,Technical, Interview hot topics, Implementation Project,End to end flow,Interview tips,BI Scenario and SAP Certification Guide etc.
There is very few content in BO present in Internet/Market at free of Cost. This channel is help you out with SAP BOBI Domain.You will get full information about Architecture,Functional,Technical, Interview hot topics, Implementation Project,End to end flow,Interview tips,BI Scenario and SAP Certification Guide etc.
SQL Traps in BO
This Video describe the SQL Traps in BO. IT define what are the SQL Traps ,Types of traps and how it create issue in Universe.
It also explain the Traps with example and describes the resolution as well.
Chasm Traps
Fan Traps.
It also explain the Traps with example and describes the resolution as well.
Chasm Traps
Fan Traps.
มุมมอง: 7 510
วีดีโอ
BO Loop and its Resolution
มุมมอง 8K7 ปีที่แล้ว
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
@Function in BO
มุมมอง 4.9K7 ปีที่แล้ว
This video describe all @Function in SAP BO. It explain the BO @Function with examples. @Prompt @Select @Where @Aggregate Aware It also Provide description on Index Awareness as well.
Joins In SAP BO
มุมมอง 3.1K7 ปีที่แล้ว
Describe about the types of Join in SAB BO. Equi Join. Outer Join. Shortcut Join. Self Restricting Join. Theta Join. Isolated Join Isolated Joins are the joins those are not involve in any Context.
Connection in SAP BO
มุมมอง 2.5K7 ปีที่แล้ว
Describes about types of connect when creating a new universe as BI Developer or Designer.
Sanjay Sir please upload new videos
Hi
Hi
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🙏
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.
@@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.
Thanks so much. You explained the concepts very well.
Nice Explaination dude, completely covered loops, can You do a lecuture on the ambigious query as well from report perspective
Thank you for so detailed explanations!
Hi admin, please continue to do this series
Bo is now done and dusted
thanks
Great Explanation and it is Useful...!!! Index awareness took a bit longer.
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
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.
Very Nice explanation :) ...keep up the good work.
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..
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?
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.
Thanks friend Well explained...
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: venu.velampati@gmail.com
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?
Thank a lot Bro.. Very well explained.. 👍👍
Hi, could you explain what will happen if loop with all tables with one to one Cardinality
Hi, I am not able to create a loop with all table in 1 to 1 relationship. Could you please explain with an example.
felling good to hear that ...Thank You
Nice! Can you please send me your email here topibal21@gmail.com. I have some questions. Thanks
Done ! Please check your Mail
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)
thanks brother..:)
Glad to Help You :)
nicely explained
Thank you :)
This video helped me to get more insight.. great (y)
thanks awesome video