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.

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)

Answer / subhash

Loop is nothing but a closed circular flow; it can be
overcome by making use of Alias and Context.

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

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

1. what are the differences between prompt at universe level and prompt at report level ? 2. what are the connection types in BOXI ? 3. how do we give the security in universe level ? and report level ? and objects level ? 4. what will happen if we check the 'MULTIPLE SQL STATEMENTS FOR EACH MEASURE' option in Universe SQL parameters ?

2 Answers   Mphasis,

---

When we r going for Short_cut join & It's Resolution??? Plz provide one scenario??

2 Answers   Rolta, TCS,

---

disadvantages of boxi

2 Answers   Accenture,

---

what is meant by scorecards?

2 Answers   TCS,

---

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

0 Answers  

---

---

WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?

2 Answers  

---

What is security domain in Business Objects?

4 Answers   Polaris,

---

what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash

2 Answers  

---

how to create a derived table in designer? i need steps regarding derived table

1 Answers  

---

what r the disadvanges in boxir2

3 Answers   Accenture,

---

how to do scheduling in desktop intelligence in BO XI R2

3 Answers  

---

What is the definition of derived table ?

2 Answers   JPMorgan Chase,

---