1 Data warehouse access - High performance analytics starts with optimizing SQL queries to retrieve results from the data sources, including relational databases and big data sources, as quickly as possible. The analytics platform’s performance is dependent largely on the time that the queries take to execute in the database and other data sources. An average reporting request can spend over 80% of the query time executing in the database and other data sources. Therefore, it is critical to optimize report queries to reduce data source execution time.
2 System architecture and configuration - Successful analytics platform applications accelerate user adoption and enhance productivity, resulting in demand for more users, data, and reports. You can further improve your MicroStrategy platform performance by tuning different components, including Intelligence Server, Web server, and client machines.
3 Caching options - Caching options refers to caching and Intelligent Cubes. MicroStrategy’s memory technology is engineered to meet the increased demand for higher analytics platform performance. MicroStrategy can improve performance by caching results and placing them into memory to dramatically improve real-time query performance.
4 Data transfer - Data transfers over one or more networks are a very important component of an analytics platform implementation. A slow or poorly tuned network performance in any of those transfers will translate into poor performance from a report or dashboard execution perspective. By properly tuning your network, you can significantly improve your network performance and distribution services executions.
5 Data rendering - Also known as data presentation or client rendering, data rendering refers to the display of the data on the client machines. Dashboards provide graphical, executive views into KPIs, enabling quick business insights. Using dashboard design optimization techniques, you can further speed up data rendering in both mobile and Web environments.
From the below link:https://community.microstrategy.com/s/topic/0TO44000000FlkEGAS/sql-generation-u080