1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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

Question Posted / mail2nare

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

any difficulitis have you phase while creating bo reports and how did u solve it

0 Answers  

Can anybody explain me ? without creating the alias can we resolve the fantrap?

4 Answers  

how to do Ad-hoc reporting ?

6 Answers   IBM,

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

3 Answers  

how will you move the universe/report from development to production?

3 Answers   TCS,




What are @FUNCTION?

4 Answers  

HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?

5 Answers   HCL,

HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?

2 Answers   Polaris,

1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?

1 Answers   Virtusa,

what is aggregate navigation?

3 Answers   Countrywide, CTS, HCL,

what is xcelsius architecture?

0 Answers   Zensar,

solve the following loops? dimension table fact table fact table dimension table link will be there between tables?

4 Answers  

For more Business Objects Interview Questions Click Here
Categories