2.What is loop? How resolve the loop?explain it?

Answer Posted / srikanth

loop can produce instances of a query where too few rows of data..
by using able aliases and contexts to resolve the loop.
alliases means it breks the loop and it is same as the original table only differ in name..a table occurs twice in the query with the diff purpose.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what would you consider as your biggest achievement and why?

569


Explain about a tricky situation for which you found a very simple solution?

532


What is a bo repository?

586


Can Bo generates the Report from the cubical data Explain?

1626


What is Indexing? how did u implement indexing?

1806






Explain what are the steps to do to use alerts in bo?

603


is it possible to export the webi reports to crystal reports?with out using businessview?

1811


any difficulitis have you phase while creating bo reports and how did u solve it

2987


Can we configure two instances of CMS pointing to two different CMS system databases?

1482


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 ?

1565


Explain is there any default username & pwd for bo designer & supervisor?

591


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?

1770


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1749


What is difference between custom hierarchy and report based hierarchy?

545


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

2111