if we run a report it is taking so much time to display the
report,what to do to increase th performance of the report

Answers were Sorted based on User's Feedback



if we run a report it is taking so much time to display the report,what to do to increase th perfo..

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.

Is This Answer Correct ?    5 Yes 0 No

if we run a report it is taking so much time to display the report,what to do to increase th perfo..

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...

Is This Answer Correct ?    1 Yes 0 No

if we run a report it is taking so much time to display the report,what to do to increase th perfo..

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

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Business Objects Interview Questions

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

0 Answers  


what r the main topics to prepare for the crystal reports? could any on help me? i want to preparing for the interviews? and also send any pdf file?

1 Answers   TCS,


generally how do we get information for creating universes and reports

1 Answers   Satyam,


if we shortcut join between two tables what will be the output?that it will give all columns or same columns?

2 Answers  


In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?

4 Answers   Cap Gemini,






bo 6.5 is a 3 tier architecture. Tell me the names of the tiers?

7 Answers   PCS, TCS,


How maually can i define ? If thousends of records exists in a table?

1 Answers   Infotech,


how can we overcome by loops?and also is it possible ,one user can different universe

4 Answers  


Is import wizard, report conversion tool, report comparison tool, security viewer ---- where all r migrating tools. whether all the tools available in BOXIR2? ..

2 Answers  


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

0 Answers  


What is thin client And thick client..?

2 Answers  


Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik

1 Answers  


Categories