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
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 2020 release Note: When upgrading from releases prior to 2019, or Data Engine Version 10, please refer to Data Engine changes impacting the upgrade to MicroStrategy 2019 for Data Engine changes introduced in those releases.
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 |
DE93734 | Data | KB483781:Compound Attribute sorting is changed when using data engine version 12 | 2020 | 2020 |
DE133375 | Data, CSI | KB483572: Wrong Join path on Nested Derived Attributes caused incorrect metrics value | 2020 | 2020 |
DE105518 | Data, CSI | KB483561: Aggregate From Base metric defined on two unrelated metrics returns incorrect data in Connect Live mode | 2020 | 2020 |
DE127043 | Data, CSI | KB483574: Visualization Using Data from Multiple Datasets Does Not Return Data Because the Maximum Number of Intermediate Rows is Exceeded | 2020 | 2020 |
DE112925 | Data, CSI | KB483648: Aggregate From Base Conditional Metric Filtered by a Relationship Set Qualification that is Related By A Fact or Metric Returns an Unspecified Error | NA | 2020 |
DE125153 | Data, CSI | KB483618: Incorrect SQL Syntax is generated for Live Connect dossier when MQ and related DA is used in the filter | 2020 | 2020 |
DE123585 | Data, CSI | KB483753: Description fail to display after linking MTDI cube attribute to project existing attributes | 2020 | 2020 |
DE133745 | Data, CSI | KB483317: Incorrect values for metric defined from attribute when filter is applied in live connect mode | 2020 | 2020 |
DE119566 | Data, CSI | KB483665: In Data Engine Version 11, CSI Changes for Subset Reports Run by Users with Security Filters | 2020 | 2020 |
US144497 | Data, CSI | KB483638:Support metric guide for metric defined on attribute or row count metric when the metric is calculated in Blending | 2020 | 2020 |
US146230 | Data | KB483734: Attribute description derived from schema object failed to display for non-English user | NA | 2020 |
DE139784 | Data, CSI | KB483563: Advanced filter qualification causes visualization to return incorrect data in a dossier where data blending occurs | 2020 | 2020 |
DE131538 | Data | KB483590: Search bar does not work for prompts with “Use a predefined list of hierarchies” setting | 2020 | 2020 |
DE136998 | Data, CSI | KB483587: Derived Attribute that is Nested on More than Three Layers Returns Incorrect Data | 2020 | 2020 |
DE136699 | Data, CSI | KB483583: Nested Derived Attributes created with Case Function may have incorrect relationship and join order | 2020 | 2020 |
DE147905 | Data | KB483717: toDateTime function behaves differently in m2020 with data engine 12 compared with previous releases | 2020 | 2020 |
DE138933 | Data, CSI | KB483755: Poor performance due to full outer join unrelated attributes for metric define on attribute | 2020 | 2020 |
DE124465 | Data | KB483635: Histogram Does Not Load When Using an Attribute Duplicated From a Metric | 2020 | 2020 |
DE131872 | Data, CSI | KB483617: Attribute results are blank after mapped to project attribute with different language preference | 2020 | 2020 |
DE104430 | Data | KB483614: Derived metric returns null value if it contains another derived metric which has a derived attribute with currentTime function | 2020 | 2020 |
DE137523 | Data, SQL, CSI | KB483581: Embedded metric with NonAgg Grouping level used Derived Attribute leads to wrong result | 2020 | 2020 |
DE145994 | Data | KB483765: Unspecified error in Dossier when case function used in the metric | 2020 | 2020 |
DE110519 | Data | KB483762: Grid cannot load due to a memory request has exceeded a limit | 2020 | 2020 |
DE150215 | Data | KB483763: Derived metric value in the footer section with grouping is not correct in documents after upgrading from 9.4.1 to 10.11. | 2020 | 2020 |
DE135161 | Data, CSI | KB484076: Absolute relationship with report filter is not correctly applied when defined in a metric | 2019 | 2020 Update 1 |
DE152648 | Data, CSI | KB484088: Calculation changes for non-distributive metrics against the Intelligent Cube after upgrading from MicroStrategy 10.4 to MicroStrategy 2019 Update 2 | 2019 | 2020 Update 1 |
DE157129 | Data, CSI | KB484101: Replacement for linked attributes | NA | 2020 |
DE151153 | Data, CSI | KB484089: No data is returned for aggregate from base metric when a filter is on derived elements | 2020 | 2020 Update 1 |
DE165483 | Data, CSI | KB484256: When a security filter and metric sum(fact+derived metric) in Connect Live mode are applied, an error occurs | 2019 | 2020 Update 2 |
DE158841 | Data | KB484700: An additional empty row is observed for a Derived Attribute | 2020 | 2020 Update 1 |
