Answer Posted / venukrishina
loops an exist when joins between tables forms continous paths.
loops are produce a cartesign product result(less number).
in bo we have 3 methods for resolve loops.
1.aliase
2.context
3.short cut joins
aliase:an aliose is exact duplicate of the orginal table with new name of the both table
context:context is a set of joins to satisfies to one business requiremt
short cut joins : is an alernative path between two table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between union and group?
explain in detail about type 3?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What are the join problems comes appart from loop,chasm & fan Traps
Explain when to use local filter and when to use global filter?
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
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
What is the difference between the public object&schema object?
Which versions are used in the bo dashboard work?
What is a fantrap in business objects?
What are the steps to do to use alerts in bo?
Explain is there any default username & pwd for bo designer & supervisor?
Explain difference between zabo and webi?
What is thumbnail?
how get the grand total in master-detail report?