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 Data. 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
Acronym used:
"CSI", which stands for "Cube Subsetting Instruction". A SQL like query which is generated by SQL Engine and run against MicroStrategy In-Memory Intelligent Cubes to retrieve data.
Internal ID | Impact | Community Article Name | Data Engine Version | MicroStrategy Version |
|---|
DE165055 | Data, CSI | KB484914: Fix the data issue when the derived metric in dossier visualization is using base metric from different dataset with Data Engine Version 2021 | 2021 | 2021 |
DE151152 | Data, CSI | KB484911: Fix the problem that Visualization returns no data when Security Filter is based on one attribute used in a temprelation which is generated by Data Blending with Data Engine Version 2021 | 2021 | 2021 |
DE166446 | Data, CSI | KB484910: Fix visualization failure issue when it contains multiple smart metrics from different datasets using same base metric with Data Engine Version 2021 | 2021 | 2021 |
DE163102 | Data, CSI | KB484799: Fix the document execution error when there is complex Derived Attribute defined on another Derived Attribute | 2020 | 2021 |
DE165020 | Data, CSI | KB484909: Fix the problem that constant metric returns NULL when using Data Blending with Data Engine Version 2021 | 2021 | 2021 |
DE170931 | Data, CSI | KB484907: Eliminate unnecessary Cross Join to improve performance when the Cross Join table is only added to apply unrelated filter with Data Engine Version 2021 | 2021 | 2021 |
DE173168 | Data, CSI | KB484915: Read NULL setting from base metric for Grand Total Metric with Data Engine Version 2021 | 2021 | 2021 |
DE174049 | Data | KB483244: A Conditional metric returns nothing instead of NULL during aggregation in a metric-only grid | 2021 | 2021 |
DE182675 | Data, SQL | KB484803: Fix the document execution error for complex Derived Metrics with nested Derived Metrics defined on Derived Attributes | 2020 | 2021 |
DE189525 | Data | KB484917: Disable double aggregation for metrics defined like M2 = Sum(M1) and M1 = Sum(Fact) | 2019 | 2021 U1 |
DE193691 | Data, SQL | KB484918: Fix the data issue when link attributes between Live dataset and In-memory dataset and use filter from both datasets with Data Engine Version 2020 | 2020 | 2021 U1 |
DE201732 | Data, SQL | KB485114: Fix the data issue on a dossier/report/document caused by the setting of Outer Join for attributes | 2020 | 2021 U3 |
DE206275 | Data, SQL | KB485167: Fix the server crash when using derived transformation metric in data blending case | NA | 2021 U3 |
DE199994 | SQL | KB485175: Enhance a SQL Global Optimization case | 2021 | 2021 U3 |
DE213924 | Data | KB485238: When sorting ascendingly on a "Derived Attribute", it orders the uppercase letters first and then the lowercase letters on the sort ascending. | 2021 | 2021 U4 |
DE215798 | Data, SQL | KB485269: Null is returned for some metrics in data blended dossiers which contain view filters on complex derived attributes | 2020 | 2021 U4 |
DE215490 | Data, SQL | KB485266: Wrong data is returned in data blended dossiers due to BreakBy/SortBy not supported in nested metrics involving OLAP functions like RunningSum | 2021 | 2021 U4 |
DE212625 | Data, SQL | KB485267: A random query execution error happens in data blended dossiers with error message "In-memory query execution failed against the Intelligent Cube due to duplicate rows found in one of the fact tables" | 2020 | 2021 U4 |
