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

Can i apply drill through on chart in report studio?

4 Answers   TCS,

---

how to get the all values from a prompt using 'ALL' use and display value in prompt

3 Answers  

---

What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?

5 Answers   IBM,

---

How many fact tables you have in your project?

1 Answers   HCL,

---

1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?

1 Answers  

---

1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

0 Answers  

---

what is render variable

5 Answers   Accenture, Cap Gemini, Systime, TCS,

---

can we insert all types of charts in a list report? what r the realtime prompts?

0 Answers  

---

I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012.

2 Answers   IBM,

---

WHAT STEPS SHOULD BE TAKEN BY A REPORT DEVELOPER TO INTERACT WITH THE CLIENT SERVER?

1 Answers  

---

17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?

3 Answers   TCS,

---

-----------With out using DrillThrough how to do Reports?

0 Answers   IBM,

---