2.What is loop? How resolve the loop?explain it?

Answer Posted / vidya

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…

ALIASES
•Alias - Same as the namesake in SQL.
•Exact duplicate of the original table.
.A different name “tricks” the SQL query to accept that you
are using 2 different tables.

CONTEXTS
•Rule which helps BO decide which of the 2 paths to choose
in a loop.
•BO prompts the user to indicate the correct perspective
(relevant path) for the query.

When to Alias
A loop with a single lookup table should be resolved by an
alias
A lookup table can be identified by its cardinality
A lookup table only has the ‘one’ end of joins attached to
it

Is This Answer Correct ?    66 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

871


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

845


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?

10389


Can more than 1 metric be applied on an analytic in business objects?

1893


Can we Save (save as) WEBI Doc as DESKI?

7606


Explain when we use aggregate awareness function in designer?

809


Explain about a task that really tested your analytical abilities?

1030


What is the difference between business requirement document and use case document.

800


8. How much supervision have you typically received in your previous job?

2043


in sap bi we have wad, then why we go for sap bo

3091


Explain what are the steps to do to use alerts in bo?

835


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2209


How would you format some text using css to be verdana and bold?

888


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

2842


Did you face any problems while creating reports? Name? Solutions?

3499