Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is a loop? How can we overcome?

Answer Posted / srikanth

Loop is one of the join path problem that arise when
designing the universe.While setting up joins between
tables,a closed path may occur between set of joins.This
scenario is called Loop.Because of this you will get
incorrect results in report.

You can avoid this problem by creating alias table or
Centext(define path for set of joins to follow)

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the measure objects?

970


What Is Snow Flake Schema?

1180


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

10366


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2210


What is the dense rank?

1201


How to execute the plsql procedure from the report by clicking with mouse?

1116


8. How much supervision have you typically received in your previous job?

2240


what are the day to day activities of BO administrator ?

3013


How many universes can be created in a project?

1021


Can anybody tell me what are the tuning problems?

2033


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2269


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2306


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1024


Explain what is aggregate table and aggregate fact table ... Any examples of both?

1098


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1002