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
Answer Posted / 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 View All Answers
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain is there any other repository domains rather than universe, security, document?
is it possible to export the webi reports to crystal reports?with out using businessview?
What is difference between custom hierarchy and report based hierarchy?
Difference between b.o 5.1 and 6.1b?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
What is the dense rank?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
Explain about a time when you discovered a more efficient way to do a work task?
Explain what are the measure objects?
how to create metric universe ?
What we need to discuss with designer before starting the universe designing.