Loop is one of the join path problem that arise when designing the univer

What is a loop? How can we overcome?

Question Posted / srikanth

5 Answers
10221 Views
I also Faced
E-Mail Answers

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 can you first report in Business Objects by using broadcast agent?

3103

What are the steps to be taken to schedule the report?

1001

What is a fantrap in business objects?

1225

What are all difference between business objects 6.5 and xi r2?

1088

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3633

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1915

Difference between zabo and webi?

1150

Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

2096

explain in detail about type 3?

1066

What Is The Difference Between Oltp And Olap?

1166

Explain what is the difference between business requirement document and use case document.

1066

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

2387

What three things do you consider to be the most important factors for a manager?

1138

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

2197

Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

1307