A report is taking few seconds to run.The same report is taking very long time on the next day without doing any kind of changes in the report. What could be the reason? how do you tune the report.
Answer / balav
First make sure you,
1. Check for the Backend loads being run on the time of report execution.That might also impact the report execution time.
2. But in future to avoid this long run, you can check the SQL global optimization setting of VLDB properties.
| Is This Answer Correct ? | 5 Yes | 1 No |
Can intelligence server integrate with my existing data structure?
Explain fact table?
hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com
What are prompted filters?
Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?
What is microstrategy desktop?
What is percent-to-total shortcut metric in microstrategy?
what is a security filter?
what do you mean by kimball?
Your application mode has crashed. How would you get the instance back?
Explain true primary keys?
While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?