Answer / prakash

Are you asking Business Objects reports tuning, if "Yes"
then, the answer is

- By reducing the number of variables
- By reducing the number of Data providers
- By pulling the exact amount of the data from the database
- By reducing the complex variables
- Do not check the "Refresh on open " report.

these are the some of the possible ways of tuning the
reports.

Answer / v.sivakumar

To add some with the before answers

Avoid Using objects from dreived tables.

Reduce the joins in the query.

Create index in the database level.

Apply the filter Properly as per the logic

Answer / satya

In a generic value report tuning is to give a final touch
to the report before putting it to production server.

Answer / naveen.g

using prameters in universe level.
creating view in database level.
creating index in database leavel.
increasing araay fetch size.
increasing arry bind size.
using correct operator,expression in report level.

Answer / gowthami

Removing unwanted objects from BO query panel
Removing unwanted variables
Prefer to prompts instead of drill filters or input control or block filters

I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers

1 Answers   IBM,

---

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

1 Answers   Wipro,

---

Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

0 Answers  

---

What is the difference b/w breaks and sections

2 Answers   IBM,

---

when you have three fact table and there is no relationship between them. How you will tackle the issue.

2 Answers   BMC, TCS,

---

---

how we transport universes from business objects 6.5 to BOXI R2?

3 Answers  

---

How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?

1 Answers   TCS,

---

how we improve the performance of report and universe?

4 Answers   Accenture, IBM,

---

how to improve the performance of the report

3 Answers  

---

HOW TO PUBLISH A REPORT IN BO?

1 Answers   Polaris,

---

I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?

3 Answers   Wipro,

---

How to add additional objects or tables into the universe,and what are steps we need to follow to achieve the above task.

1 Answers   Patni,

---