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 |
I have scheduled a weekly report to client. If the data is Over which client wanna receive what will happen?
Can you please send me the migration related issues .
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
2 Answers Accenture, Rolta, TCS,
what is document design in boxi,have u participate in that
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
What is the difference between sub-query & co-related sub query?answer ASAP....... thanks in advance..............Prakash
3 Answers iFlex, Maintec, TCS,
What is the local filter and global filter in bo's?
what is prompt? Cascading prompt? Syntax
any of the person working on encyclopedia? give the explanation briefly?
Hi,can anybody help me to do like this, i have one dp with agerange, first name ,Address. And another dp is agerange,age min , last name. in this two data providers agerange is common . I want to see in my report all the fields . How i can merge it ?
what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?
Explain how we drill up week to month?