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

Quality Architect, Senior • MicroStrategy

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

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 2021 from MicroStrategy 2020 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 2021 release

Internal ID	Impact	Community Article Name	Motivation For Change	Data Engine Version	MicroStrategy Version
DE158497	Data, CSI	KB484906: Fix the problem that security filter is not partially applied when generating Many-to-Many relations and sometimes leads to "Intermediate Row limit exceeds" error with Data Engine Version 2021	Stability	2021	2021
F18650	SQL	KB484145: Improving report and cube performance against the data warehouse by using an attribute form caching cube	Performance	N/A	2021
DE172805	SQL, CSI	KB484832: Optimize CONCAT expression containing multiple constant Strings to improve performance	Performance	2021	2021
DE158548	SQL	KB484901: For SQL reports, users may see invalid data type in 'create table' statement which leads to execution error for such report	Stability	2021	2021
DE170977	Data, CSI	KB484903: Optimize Table Join Path for applying filter to improve performance with Data Engine Version 2021	Stability	2021	2021
F22581	SQL	KB484742: Improved performance by push down of Percentile function to the data source	Performance	2021	2021
DE179745	SQL	KB484913: Custom plug-in function with the function type Comparison is supported in MicroStrategy 2021	Performance	N/A	2021
DE174991	Data	KB484944: Due to correct reporting of "Working set Cache RAM Usage (MB)" governing, users may see error “The Maximum RAM for Working Set cache limit has been exceeded with this request.” may be seen more often	Performance	N/A	2021 U1

Comment

0 comments

Details

Knowledge Article

Published:

March 21, 2024

Last Updated:

March 21, 2024