2.What is loop? How resolve the loop?explain it?
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 do u mean by merged dimensions in Business Objects
2 Answers Business Intelligence Analytics, TCS,
WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?
Difference between scope of analysis in webi and in deski?
What is security level in BO ?
How many ways you can restrict data in business objects?
I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)
Explain about a time when you discovered a more efficient way to do a work task?
What Is Snow Flake Schema?
Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important
what is fantrap?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.