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
what are the day to day activities of BO administrator ?
How we drill up week to month?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
How to schedule the report in b.o?
When to use local filter and when to use global filter?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Differences between business objects and web intelligence reports?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Explain difference between zabo and webi?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain what are the measure objects?
Explain about a task that really tested your analytical abilities?
what is xcelsius architecture?
Explain what are the steps to be taken to schedule the report?
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.