Answer / s.srinivas

A LOOP IS A CLOSED PATH IN FRAME WORK MANAGER DUE TO
JOINS.WE ILL RESOLVED IT BY CREATING ALLIAS AND CREATING
SHORT CUTS

Answer / samir kumar sahoo.

A LOOP IS NOTHING BUT A CLOSED PATH DUE TO JOINS IN FRAME
WORK MANAGER. THE JOIN CONSISTS OF ATLEAST THREE TABLES.
THIS PROBLEM CAN BE RESOLVED BY USING ALIAS OR SHORT CUTS.
THE LOOP GENERALLY DEGRADES THE PERFORMANCE BECAUSE IT TAKES
MORE EXECUTION TIME AND DISPLAY WRONG RESULTS DUE TO A
NUMBER OF JOINS.SO WE BETTER TRY TO AVOID USING OF LOOPS IN
FRAME WORK MANAGER TOOL.

Answer / shekar

loop is closed path in reportnet it called as ambigous
relation ship. that means a query subject contians
multipule paths to retrive the data
it is a exception to reslove to create a shortcut on that
query subjet
other wise it displys wrong results in reports and
perfomens is digreegs.

Answer / uzval

A undefined join between two tables is known as loop.

To resolve loop delete the joins,if these joins are
necessary then we have to create shortcuts nothing but
alias tables.Place the joins in alias tables

Due Date (Highlight Issues in Blue where Due Dates are less than Todays Date),I have only Due Date column then how to over come the problem.How to find out which Due Date are less than Today Date...Kindly provide the detail steps to my mail ID-->asimcognos10@gmail.com

2 Answers   IBM,

---

What do you understand by the term 'aggregate advisor?'

0 Answers  

---

how to convert crosstab into list?

4 Answers   TCS,

---

If we run a report, that has 2 pages, i want to display one page in HTML format and another page wil display in pdf format. What is the procedure?

2 Answers   IBM, Polaris,

---

what is requery in cognos?

0 Answers   HMN, Satyam, TCS,

---

what is prompt variable

2 Answers   HCL,

---

What are Governer Settings?

2 Answers  

---

how to add a new query item by using 2 query subject? For Ex: i want to create a revenue query item in products query subject(revenue=Quantity*Unitprice). Quantity is in products query subject & unit price in orders query subject it will be possible in report studio(perment/temporerally) otherwise u have create in Freamework Manager... pls any body knows explain /answer me ?

4 Answers  

---

Hi Friends, Please tell me at What situations we use the Segment, Link in FM, What is the Main Difference functionality wise? Thank You

1 Answers  

---

Interval Prompt's Usage? Example for usage in Project

2 Answers   Cap Gemini,

---

Can you define transformer?

0 Answers  

---

What is the difference between macro & Parameter

1 Answers   IBM,

---