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
Explain what would you consider as your biggest achievement and why?
Explain about a tricky situation for which you found a very simple solution?
What is a bo repository?
Can Bo generates the Report from the cubical data Explain?
What is Indexing? how did u implement indexing?
Explain what are the steps to do to use alerts in bo?
is it possible to export the webi reports to crystal reports?with out using businessview?
any difficulitis have you phase while creating bo reports and how did u solve it
Can we configure two instances of CMS pointing to two different CMS system databases?
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 ?
Explain is there any default username & pwd for bo designer & supervisor?
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?
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!!!
What is difference between custom hierarchy and report based hierarchy?
How to create Index to the table in the universe designer and how it improves the Query performence