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

what are the day to day activities of BO administrator ?

1967


How we drill up week to month?

613


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

582


How to schedule the report in b.o?

555


When to use local filter and when to use global filter?

593






Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

547


Differences between business objects and web intelligence reports?

650


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1743


Explain difference between zabo and webi?

645


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?

541


Explain what are the measure objects?

543


Explain about a task that really tested your analytical abilities?

744


what is xcelsius architecture?

3734


Explain what are the steps to be taken to schedule the report?

631


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.

1878