2.What is loop? How resolve the loop?explain it?
- 11 Answers
- 61879 Views
- TCS, UHG, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vidya
Loop is a Multiple paths between the tables selected in
queries. Or you can say loop is a closed path structure.
Loops can be resolved by…
ALIASES
•Alias - Same as the namesake in SQL.
•Exact duplicate of the original table.
.A different name “tricks” the SQL query to accept that you
are using 2 different tables.
CONTEXTS
•Rule which helps BO decide which of the 2 paths to choose
in a loop.
•BO prompts the user to indicate the correct perspective
(relevant path) for the query.
When to Alias
A loop with a single lookup table should be resolved by an
alias
A lookup table can be identified by its cardinality
A lookup table only has the ‘one’ end of joins attached to
it
| Is This Answer Correct ? | 66 Yes | 4 No |
Answer / rahul tandon
Loop is a situation in the BO universe design process. A
circular path of joins is formed between the tables. The
SQL queries are not able to interpret the joins; this
results in the wrong results from the queries; often less
records are retrieved than the actual number of records.
A loop situation can be resolved by Aliases and Contexts.
Make sure to break the joins(circular path) by aliasing the
table(dimension table) which has 1n's coming out of it from
both the end. The path then gets broken and ends as two
different path, one ending at the original dimension table
and the other at the aliased table(of that dimension). Both
of the paths now convey a differnt business case scenario
and depending upon the scenario a particlar path(query has
to be fired).
| Is This Answer Correct ? | 16 Yes | 1 No |
Answer / vams_gk
loop is nothing but a continuous data flow .it is a pipe
line.it is a close path end to end..using alias table we
can resolve loop s
| Is This Answer Correct ? | 18 Yes | 8 No |
Answer / stalin
Loop is a Multiple paths between the tables selected in
queries. Or you can say loop is a closed path structure.
Loops can be resolved by
1.Aliasing
2.Context
3.Short cut join
if our table having only one lookup then we go for the alias
concept to resolve the loop.
if our table having more than one lookup the we go for the
context to resolve the loop
Short cut join will also resolve the loops
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / chakri
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.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / 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 |
Answer / chaitu
Loop is a closed circuit path.it fetches the less number of records than we expected.
by resolve these loops we are having three methods
1)context
2)Alias
3)short cut join
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / veeru
@loop:
we can say simply like:
loop is a contineous path between
the tables.
we can say another way: if there are number of tables
extractiing with number of ralations ships connecting with
each other is called loop.
two ways to we can resolve the loop
1) Alias
2)context
if our table having only one lookup then we go for the alias
concept to resolve the loop.
if our table having more than one lookup the we go for the
context to resolve the loop
| Is This Answer Correct ? | 2 Yes | 2 No |
what is merged imension in 6.5 and webi
how can we build one report from two data bases
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?
When we go for OLAP , and When we go for OLTP for generating the reports ?
1. I have 2 universes. that is u1 and u2. From u1,i created one report that is r1. Now i want to give the connection r1 to u2 and at the same time delete the connection from u1 to r1 ? How is it possible explain? 2.How can i schedule the reports in BOXIR2?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
How do you find what type of trap is there by seeing the report?
what is the difference between breaks and sections?
Can we use unconnected lookup as dynamic lookup?
Explain what task is 98% of the required work of a business analyst?
Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?
Teradata 
