What is a loop? How can we overcome?

Answer Posted / nareshkumar

A loop is a set of joins that defines a closed path through
a set of tables in a schema. Loops occur when joins form
multiple paths between lookup tables.

Loops can be solved by using aliases or contexts.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to create reports on screech?

2074


What is the dense rank?

671


How many universes can be created in a project?

597


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3843


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

2994






How were the reports scheduled and how to resolve unexecuted documents?

2210


What are the steps to do to use alerts in bo?

627


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1475


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2597


Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

539


Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

621


What is thumbnail?

578


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1487


Explain the difference between union and group?

622


What is difference between webi and infoview?

613