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

Answer Posted / g.v.subramanyam

a situation occures more than one path exists from one table
to another table.
to reslove the loops we can use the allias ans context.
if a loop contains only one lookup table then the loop can
be resolved by detecting the alias.
if a loop is having 2 or more fact tables(multiple fact
tables) then the loop can be resolved by detecting context.

Is This Answer Correct ?    71 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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?

552


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

579


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

2994


What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1557


Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1583






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

1399


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

600


Explain difference between zabo and webi?

653


How we drill up week to month?

619


What is the profile and package?

1767


how get the grand total in master-detail report?

1817


What is the functional & architectural differences between business objects and web intelligence reports?

557


What are the join problems comes appart from loop,chasm & fan Traps

1553


in sap bi we have wad, then why we go for sap bo

2779


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

615