Answer / srikanth

Remove unnecessary objects and variables if any.make sure
you remove alerters if any unless it is the
requirement.Take the report query and run in Database.See
how much time its taking.From report query check whether
in 'where' clause columns have indexes.If not discuss with
oracle admin and add indexes.

Answer / ilaw

If the question is not pertaining to query optimization, I
would prefer not to use much of formatting on the page. One
can keep the report without any page formatting as this
would take a very long time. Try not to use the slice &
dice panel as this would also take considerably long time...

Answer / vams_gk

if we run a report it is taking so much time to display the
result to be fallowed as :

1) use aggrigate tables(contains pre caliculated data)
2)pre defined conditions,LOV's
3)in a real time senario query contains a large if
statements.some times we need to wait max of 30 min to run
perticular statement...not all

how we send repotrts/documents to end user

2 Answers   HP,

---

how to hide the prompts?

7 Answers   TCS,

---

wat is difference b/w break and section?

4 Answers  

---

How to generate the report from excel sheet?

0 Answers  

---

how to make a report avilable to other users?

2 Answers  

---

Explain about Short cut join?

2 Answers   Wipro,

---

can u create report to connect oracle and sqlserver at a time?

2 Answers   Zensar,

---

I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.

3 Answers  

---

How many ways you can restrict data in business objects?

5 Answers   TCS,

---

How can you check the universe?

3 Answers  

---

Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu

2 Answers   Infosys,

---

If any one Deleted the BOMain key by accidently,is any possible to get back that Bomain key.if possible please send some steps.

2 Answers   iFlex, Pfizer,

---