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
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 |
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 |
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 |
difference between web intelligence,crystal reports and desktop intelligents
how to prepare the documentation in business objects and where to get the requirement?
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?
Can we use unconnected lookup as dynamic lookup?
what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance
wat is report linking in BO..I know that 2 reports can be linked in BO with the help of writing a HTML code .But how. wat s the code.can u give me the example of code taking e fashion as the simple univers data provider.
How to check for a particular value from one column with the list of values present in another column in Webi reports?
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
What is the short cut join?
IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION?
How to change English language to Chinese in BO Desiner (Universe)?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?