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.
- 1 Answers
- 4234 Views
- Infosys, I also Faced
- E-Mail Answers
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 |
What according to you are the roles and responsibilities of a microstrategy developer?.
In Microstrategy, how can you direct the sql generated to use a specifc table?
How does microstrategy object manager determine if two objects in different projects are the same?
What are public objects?
What do you mean by mstr?
Explain absolute filter?
What are level metrics? Why are they needed?
Is there a difference between view filter and report filter?
What do you mean by consolidations?
According to you, what are the most important tables in a dw? Why?
Your application mode has crashed. How would you run your i-server?
While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?
Teradata 
