Answer Posted / praveen
For performance tuning
1)it is done with the help of VLDB properties
2)check the intermediate sql passes and try to reduce the passes
3)apply filter conditions where ever required.
4)No cross join to be happened
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what do you mean by custom groups?
Is there a difference between view filter and report filter?
what specific features and functionality do you get with olap services?
Your application mode has crashed. How would you get the instance back?
you are required to disable webusers to use only one i-server. How would you do that?
What are report filters and view filters?
What are different types of metrics in microstrategy?
Explain fact constellation schema?
What is percent-to-total shortcut metric in microstrategy?
What is a dw? Why do we need it?
What happens if the owner of an object does not exist in the destination project?
What are the tracing options available in microstrategy object manager?
How can you make the sql query to be based on a specific table of your choice?
What is an object prompt?
Can I access intelligent cubes without olap services?
