Parallel Query Execution of below candidates are now supported since Strategy 10.11. This provides improved performance when querying in-memory cubes.
Refer to Technical Document below on how to enable the VLDB:
KB44052: How does the feature in the MicroStrategy 9.3.x SQL engine: "Parallel Query Execution" work.
Simple reports in Strategy may not require multiple queries to return the required results, so even if parallel query execution is enabled, there may be no performance benefit. However, there are various Strategy features and techniques that often require multiple queries and therefore can benefit the most from parallel query execution, which include:
• Consolidations and custom groups.
• Level metrics and transformation metrics.
• Accessing multiple data sources using MultiSource Option or database gateway support.
• Accessing data sources that use temporary tables or permanent tables to store intermediate results.
• Accessing data in multiple tables through the use of Data Import.
Additionally, using parallel query execution can be a good option for Intelligent Cubes that are published during off-peak hours when the system is not in heavy use by the reporting community. Using parallel query execution to publish these Intelligent Cubes can speed up the publication process, while not affecting the reporting community for your system.
Article Reference Number: KB440566 KB440566
