What is a loop? How can we overcome?
Answers were Sorted based on User's Feedback
Answer / nareshkumar
A loop is a set of joins that defines a closed path through
a set of tables in a schema. Loops occur when joins form
multiple paths between lookup tables.
Loops can be solved by using aliases or contexts.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / subhash
Loop is nothing but a closed circular flow; it can be
overcome by making use of Alias and Context.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vams_gk
loop is a closed path between end to end.continuous floe of
data.creation of alias table is solution to resolve loops
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
disadvantages of boxi
How can you access your repository with different user profiles?
Explain what are the steps to do to use alerts in bo?
Example of how the fantraps and chasm traps works?
What are the Errors in BO Pls Explain with Examples
2 Answers iFlex, Tech Mahindra,
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?
HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?
How to display the top 5 records along with the additional records,plus their sub and grand totals to be display in the same block.
WHAT KIND OF TOOL BO IS?
can any one tell me how to create a new universe from scrach with step by step process.
What is #DATASYNC error how to remove it?