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


Please Help Members By Posting Answers For Below Questions

Give some information on report bursting?

731


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1612


Explain what is the difference between slice and dice and cross tab report?

786


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10275


How to execute the plsql procedure from the report by clicking with mouse?

789






What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

784


How can you first report in Business Objects by using broadcast agent?

2796


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4128


Explain the difference between detect alias and detect context?

794


is it possible to export the webi reports to crystal reports?with out using businessview?

2014


Explain the data types present in bo and what happens if we implement view in the designer and report?

761


What is top business?

737


How we drill up week to month?

800


What would you consider as your biggest achievement and why?

779


Explain which versions are used in the bo dashboard work?

820