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 |
What is shortcut join?could give any one example?
HOW TO HIDE Column in WEBI & DESKI?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
How to get the data from the two different sourcess
How we can resolve the loops by using the Aggrigate Awareness?
I have Startdate,enddate objects in querypanel and prompt on those objects.how would i get before 2 years data,if i run that query.
How to Avoid the overlaping the blocks in WEBI.
Can Bo generates the reports from cubical data ? Explain?
Approximatly how many enduser can use the each bo project?
I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.
I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?
When we r going for Short_cut join & It's Resolution??? Plz provide one scenario??