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

can we create aliases for every table beforehand? if yes whar are the disadvantages?

5 Answers   AG Technologies,

---

Aliases and Contexts Which once will give the better performence when resolve the loops?

3 Answers   HCL,

---

while developing a report in BO i had created prompts at query level? When an end user runs the report he has to see the details of the report with out entering the prompt values? How can we do this in BO?

2 Answers   PWC,

---

What is the prm file ? can anybody explain me ?

2 Answers  

---

can any one tell me how to create a new universe from scrach with step by step process.

4 Answers   HCL,

---

---

HOW TO SPOT A HIERARCHY?

2 Answers   TCS,

---

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ? normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2 Answers   iFlex,

---

i want to hide a chart in reporting level? i want to hide a prompt in designer level?

1 Answers   TCS,

---

User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.

1 Answers  

---

Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

0 Answers  

---

how do u implement dense rank in a report?

1 Answers   CTS,

---

what do u mean by variable functions ?

2 Answers  

---