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
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
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?
Can more than 1 metric be applied on an analytic in business objects?
Can we Save (save as) WEBI Doc as DESKI?
Explain when we use aggregate awareness function in designer?
Explain about a task that really tested your analytical abilities?
What is the difference between business requirement document and use case document.
8. How much supervision have you typically received in your previous job?
in sap bi we have wad, then why we go for sap bo
Explain what are the steps to do to use alerts in bo?
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.
How would you format some text using css to be verdana and bold?
How can you first report in Business Objects by using broadcast agent?
Did you face any problems while creating reports? Name? Solutions?