Readers:
I have received an e-mail from a reader that wanted me to discuss how to optimize MicroStrategy Reports.
I think this is an excellent topic and will today start a new blog topic called MicroStrategy Report Optimization. This will be a multi-part series (I will leave it open-ended so I can continue to add to it).
Before we start the series, it is important to understand report execution flow in MicroStrategy. That is what I will start with today.
Best Regards,
Michael
Source: MicroStrategy University, Deploying MicroStrategy High Performance BI, V9.3.1, MicroStrategy, Inc. September, 2013.
Report Execution Flow
To better understand how some of the components affect the report performance in a MicroStrategy environment, it is important to become familiar with the report execution flow.
The following image depicts the different steps involved in the report execution process.
The following steps and components are involved in the report execution flow.
Also we can create indexes on commonly used column in database to improve report performance.
Temporary tables can be used instead of embedded sql queries to improve performance.
Very nicely explained and in easy to understand language .