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
Give some information on report bursting?
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
Explain what is the difference between slice and dice and cross tab report?
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?
How to execute the plsql procedure from the report by clicking with mouse?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
How can you first report in Business Objects by using broadcast agent?
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??
Explain the difference between detect alias and detect context?
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain the data types present in bo and what happens if we implement view in the designer and report?
What is top business?
How we drill up week to month?
What would you consider as your biggest achievement and why?
Explain which versions are used in the bo dashboard work?