2.What is loop? How resolve the loop?explain it?
Answer Posted / stalin
Loop is a Multiple paths between the tables selected in
queries. Or you can say loop is a closed path structure.
Loops can be resolved by
1.Aliasing
2.Context
3.Short cut join
if our table having only one lookup then we go for the alias
concept to resolve the loop.
if our table having more than one lookup the we go for the
context to resolve the loop
Short cut join will also resolve the loops
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is the difference in creating filters in designer and business objects?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What is top business?
What are the steps to be taken to schedule the report?
What is a bo repository?
Can anybody tell me what are the tuning problems?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
Explain when we use aggregate awareness function in designer?
What is the difference between business requirement document and use case document.
Explain what would you consider as your biggest achievement and why?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What is the difference between datawarehousing and businessintelligence?
Explain is there any other repository domains rather than universe, security, document?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...