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

How to restrict password to a user while sending a document in .pdf format

2043


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?

759


Explain what sort of existing documents should business analysts refer to when starting on a new project?

780


What would you consider as your biggest achievement and why?

785


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3546


What is a fantrap in business objects?

812


How to create Index to the table in the universe designer and how it improves the Query performence

2318


how to create metric universe ?

2081


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4491


Can we Save (save as) WEBI Doc as DESKI?

7528


what is document design in boxi,have u participate in that

1834


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)?

763


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1130


Give some information on report bursting?

745


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1732