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
8. How much supervision have you typically received in your previous job?
Can we Save (save as) WEBI Doc as DESKI?
Difference between b.o 5.1 and 6.1b?
what are the tables used in health care domain project and columns used in report?
what is document design in boxi,have u participate in that
How to create Index to the table in the universe designer and how it improves the Query performence
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
What is difference between webi and infoview?
What is the profile and package?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
what is the difference b/w the refresh and buffered data?
What is the difference between slice and dice and cross tab report?
Explain how we drill up week to month?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
how to create metric universe ?