Data Engine changes impacting the upgrade to MicroStrategy 2020 release - Performance and Stability changes

Quality Engineer, Principal • Strategy

This article discusses Data Engine changes that may impact performance and stability when upgrading to MicroStrategy 2020.

Starting with the release of MicroStrategy ONE (March 2024), dossiers are also known as dashboards.
The following is a full list of MicroStrategy Data Engine changes that may be seen when upgrading to MicroStrategy 2020 from MicroStrategy 2019 which affect Performance / Stability. These changes are to both defect fixes and enhancements for a more stable and robust reporting platform. To find out if you are hitting any of the scenarios listed below, take advantage of MicroStrategy Integrity Manager and the Upgrade Analysis Dossier. In leveraging these you can review how these changes are impacting your environment during an upgrade to the latest release of MicroStrategy. Please also see this article for more details: Data Engine changes in MicroStrategy 2020 release

Internal ID	Impact	Community Article Name	Motivation For Change	Data Engine Version	MicroStrategy Version
DE127635	Data, CSI	KB483316: Attribute outer join with preserve filter incorrectly applies cross join when filter and template attributes have a many to many relationship	Performance	2020	2020
DE133372	SQL	KB483322: Two identical tables for a full outer join twice when metric join type is set to Outer Join and SQL Global Optimization is set to level 4	Performance	2020	2020
DE124428	SQL	KB483662: Report Execution Fails When Parallel Query Execution Is Enabled With Certain Combinations of Other VLDB Settings	Stability	N/A	2020
DE140604	Data, SQL, CSI	KB483573: Metric Qualification Filter not Push Down in ConnectLive leads to performance degrading	Performance	2020	2020
US128767	CSI	KB483601: Data Engine Generates unnecessary temporary cubes when applying filter with duplicated conditions	Performance	N/A	2020
DE94933	SQL	KB483619: Report with a Custom Group Applies the Report Filter When It Should Be Ignored	Performance	2020	2020
DE114151	CSI	KB483656: CSI optimization for relationship filter built on objects using normal report as dataset	Stability	2020	2020
F28952	Data	KB484141: Improved Intelligence Server stability and Memory Management through unified Cartesian Join governing in MicroStrategy 2020 Update 2 and later	Stability	2020	2020

Comment

0 comments

Details

Knowledge Article

Published:

March 21, 2024

Last Updated:

March 21, 2024