Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 7804 Views
- I also Faced
- E-Mail Answers
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
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain how many universes can be created in a project?
What is Indexing? how did u implement indexing?
What is the profile and package?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What we need to discuss with designer before starting the universe designing.
Explain the data types present in bo and what happens if we implement view in the designer and report?
How to generate the report from excel sheet?
What is thumbnail?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
what are the tables used in health care domain project and columns used in report?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
