EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics
  3. Data Engine changes impacting the in upgrade to MicroStrategy 2019 release - Data changes

Data Engine changes impacting the in upgrade to MicroStrategy 2019 release - Data changes


Chris Robinson

Principal Product Specialist • Strategy


This article discusses Data Engine changes that may impact customers data when upgrading to MicroStrategy 2019.
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 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 impacting the upgrade to MicroStrategy 2019 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

DE66474

CSI, Data

KB439660: In MicroStrategy 10.8 and earlier, template level metric conditions are ignored when using data blending on "Live" Intelligent Cubes.

2019

2019

US95927

SQL, CSI, Data

KB440683: Starting in MicroStrategy 10.9, level metrics will have the parent attribute added to the final pass of SQL or CSI allowing better performance and calculation of subtotals

2019

2019

US81433

Data

KB483329: View filter defined as attribute form comparison results in data change when the attribute form contains null value

2019

2019

DE64146

SQL, Data

KB439692: Metrics return different data on a dashboard/dossier versus a report when used directly instead of through a dataset in MicroStrategy 10.x

2019

2019

DE68652

CSI, Data

KB439659: Subtotal of level metric calculates incorrectly after adding more attribute into the grid in a data blending dashboard in MicroStrategy 10.4 and above

2019

2019

DE68437

CSI, Data

KB439649: Metric calculates differently with filter on attribute elements and attribute group elements in MicroStrategy Web 10.7 and above

2019

2019

DE76904

SQL, Data

KB439674: In MicroStrategy 10.x, transformations do not apply to a metric when the attribute used in the transformation is not in the report objects or filter of a report.

2019

2019

DE83305

CSI, Data

KB440707: In-Memory Data Import Cube Auto Join does not consider the partitioned table if the partitioned attribute is not used in the grid.

2019

2019

DE48719

Data

KB040517: A selector configured as 'Automatically update when there is no data for the current selection' will not update automatically and will display "No data returned for this view" in MicroStrategy Web 9.4.1 - 10.6

2019

2019

DE75017

Data (mobile)

KB440686: Derived Metric value cannot be rendered on MicroStrategy Mobile

2019

2019

US7669

SQL, Data

KB34566: Attribute elements are missing descriptions or have null descriptions when running a report that uses outer joined filtered metrics and the attribute or attribute form selection option for intermediate passes in MicroStrategy 9.x and 10.x

2019

2019

F8056

SQL, Data

KB440739: Preserve and apply VLDB settings of a report when it is used as a filter into another report

2019

2019

DE39511

CSI, Data

KB439634: In MicroStrategy 10.6 or earlier, Row Count metric aggregates incorrectly when using Attribute Groups on Dashboards against a Live Connection

2019

2019

F10385

SQL, CSI, Data

KB440694: For data Import Intelligent Cube, two sibling attributes are joined on parent attribute and not through the fact table containing a join path

2019

2019

DE82869

CSI, Data

KB440831: Duplicate rows are displayed for a Dossier against a Data Import Cube when the used fact table contains duplicated rows

2019

2019

DE72285

SQL, Data

KB440641: Adding a derived metric on an attribute to a dossier results in a cross join to apply unnecessary filter

2019

2019

DE79395

SQL, Data

KB440693: Dossier data is incorrect when table with many-to-many relationship is picked up over one-to-many relationship

2019

2019

DE83062

CSI, Data

KB440712: Outer Join to lookup table is not working in a dashboard/dossier based on Intelligent Cube with joint element list filter

2019

2019

DE84985

CSI, Data

KB440718: Aggregate from base derived metric with an attribute to ignore filter does not get ignored in the metric calculation in Dossier/VI Dashboard if attribute join behavior is set to Outer Join To Lookup.

2019

2019

DE75406

CSI, Data

KB440743: Dashboard returns extra rows for Derived Attribute or Derived Element

2019

2019

DE82987

CSI, Data

KB440260: Dashboard shows unnecessary extra rows of data when using a derived attribute that is based on two different datasets that are linked

2019

2019

US100818

SQL, Data

KB440213: Row Count metric shows null values on for a dossier against a Live Intelligent Cube

2019

2019

DE72287

CSI

KB442368: Optimization for In-Memory query against Intelligent Cubes to improve filter expression for better performance which contains IS NULL or Is NOT NULL.

2019

2019

DE77247

CSI, Data

KB442142: Internal error is displayed for a dashboard containing metrics defined on attributes

2019

2019

DE86796

CSI, Data

KB442383: Outer Join setting for Metrics and Attributes does not work when using Live Intelligent Cube as dataset

2019

2019

DE98248

CSI, Data

KB442384: Attribute outer join with preserve filter does not show attribute elements for which there is no metric data available

2019

2019

DE43059

SQL, Data

KB440333: Multi-source option does not with consolidation in reports.

2019

2019

DE92045

SQL, Data

KB441491: Different Fact table is used for fact extension between Live and In-Memory Intelligent Cube

2019

2019

DE75119

CSI

KB442146: Incorrect filtering is seen when converting an attribute filter qualification to a set qualification in a dossier

2019

2019

DE101182

CSI, Data

KB441524: Derived attribute does not show correct data when it's defined on two attributes from different datasets that are linked and and contain different data

2019

2019

DE98724

CSI, Data

KB439678: Incorrect join columns are used with level metrics using outer joins

2019

2019

DE95975

CSI, Data

KB442157: Error "MDX Engine encoutered an exception" appears if there is a derived metric and derived element on the grid with security filter and filter defined.

2019

2019

DE106218

CSI, Data

KB442256: Dynamic dimensionality does not work with the new derived element for aggregation from base metric.

2019

2019

DE114934

CSI, Data

KB442257: With Data Engine Version=11, In-Memory query instruction is improvised to include the fact table in join tree if there fact table is used in SELECT clause

2019

2019

DE112169

CSI, Data

KB442261 : For a dossier using Live Intelligent Cube, filter for conditional metric is also applied to other metric if all the metrics and attributes come from same dataset

2019

2019

DE110492

CSI, Data

KB442262: With Data Engine Version=11, incorrect data is displayed due to wrong application of a filter

2019

2019

DE116995

CSI, Data

KB442263 : With Data Engine Version set to 11, data mismatch occurs between In-Memory and Live Intelligent Cube, when there are multiple conditions applied to a metric.

2019

2019

DE116716

CSI, Data

KB442264 : In-Memory query against Intelligent Cube incorrectly does a cross join instead of joining through available tables using which the attributes could be joined.

2019

2019

DE116783

CSI, Data

KB442265: With Data Engine Version=11, using a derived attribute on a dossier with multiple datasets results into incorrect data if one dataset contains duplicate attribute elements.

2019

2019

DE93077

CSI, Data

KB442267: Adding derived attribute based on multiple attributes results into incorrect metric dimensionality and data

2019

2019

DE115506

CSI, Data

KB442268: Incorrect data is displayed when "Aggregate from Base" option gets disabled for an attributes based metric when it cannot be calculated in the base dataset but in Data Blending Engine

2019

2019

DE119774

SQL, Data

KB442273: With Data Engine Version=11, visualization shows no data due to table with zero rows being picked for metric calculation

2019

2019

DE111564

SQL, Data

KB442278: Using Data Combination setting as "Min relation..." a dossier with derived attributes based on multiple attributes fails with "Unspecified error".

2019

2019

DE32748

SQL, Data

KB442279: Selectors in Report Services Document do not filter all the assigned targets

2019

2019

DE119354

SQL, Data

KB442281: Starting 10.4.8 and 10.11, a dashboard with multiple datasets using nested aggregated metric together with element group shows empty results

N/A

2019

US84468

CSI, Data

KB440794: Placing a metric from one dataset will cause an existing metric to appear blank when setting the Data Source to 'None' in MicroStrategy 10.4.5 and MicroStrategy 10.10 and lower

N/A

2019

DE56671

CSI, Data

KB440657: Subtotal values become Null when Metric limit is applied

N/A

2019

DE85025

CSI, Data

KB440700: No data is returned when applying metric set qualification to a derived metric in dossier in MicroStrategy 10.9

N/A

2019

DE91222

Data

KB440708: Filters do not behave correctly when based on Derived Elements using multiple attribute forms

N/A

2019

DE98043

SQL, Data

KB441521: SQL statement containing semi-colon (;) in the Report Pre Statement 5 VLDB properties will cause report to fail in MicroStrategy 10.x.

N/A

2019

DE99583

CSI, Data

KB442190: When using non-aggregatable metrics in Dossiers with multiple templates and chapters, incorrect values are retrieved

N/A

2019

DE101196

Data

KB442275: Covariance function uses Sample Covariance formula in Analytical Engine instead of Population Covariance

2019

2019

DE123410

Data

KB442371: "Unspecified error" is displayed for a dossier with at least two dataset with attributes linked, derived attribute and conditional metric

N/A

2019

DE104084

Data

KB483209: Non-Aggregatable Metrics in Live Connect Datasets are calculated incorrectly

2019

2019

DE94709

Data

KB483211: Dossier using a Live Connection ignores Cartesian Join Settings if the database instance is not set as the primary in Project Configuration .

2019

2019

DE24791

Data

KB483213: Cartesian joins generated through implicit or explicit relationship filters ignore the "Cartesian join warning" VLDB property .

2019

2019

DE115514

CSI, Data

KB483214: In Web, users cannot use the Break By function with a rank metric .

2019

2019

DE96587

SQL, Data

KB483216: Incorrect data is displayed when using a derived metric for "Last" in a live connected dossier using a database that does not support the function "Last."

2019

2019

DE103710

CSI, Data

KB483220: No metric values displayed after creating a Group .

N/A

2019

DE104578

Data

KB483223: Sorting Derived metrics using a New Derived Element yields unexpected results

2019

2019

DE118009

CSI, Data

KB483230: Application of Dataset Relation Filter is not as expected .

2019

2019

DE87432

SQL, Data

KB483233: An Aggregate From Base (AFB) metric defined on Row Count is incorrectly calculated

2019

2019

DE112741

Data

KB483227: Job canceled after adding a subtotal to the template. The template uses a Connect Live Dataset .

2019

2019

DE94920

CSI, Data

KB483236-Metric-defined-on-RowCount-shows-incorrect-value

N/A

2019

DE102071

Data

KB483239: Running Sum metrics with an Attribute Group illustrates incorrect values on a bar chart, but correct values on a grid .

2019

2019

DE86726

Data

KB483240: Incorrect aggregated metric value displayed after removing all attributes

2019

2019

DE98392

SQL, Data

KB483243: Incorrect SQL is generated for the filter of a Derived Attribute based on a Date type attribute. This leads to an empty grid

2019

2019

DE101467

Data

KB483244: A Conditional metric returns nothing instead of NULL during aggregation

2019

2019

DE103086

Data

KB483247: A Derived Metric using the Yield function displays unexpected results .

2019

2019

DE95001

CSI, Data

KB483253: Aggregate from Base (AFB) conditional metric with components in different datasets displays unexpected value .

2019

2019

DE121578

Data

KB482991: Small data difference-is observed between parallel and sequential metric calculation

N/A

2019

DE123579

CSI, Data

KB482972: Count metric does not calculate correctly when it is using as a component of another smart metric

2019

2019

DE110373

CSI, Data

KB483191: Incorrect filtering with another visualization in a dossier causes missing data.

2019

2019

DE117141

Data

KB440049: Individual metric columns hidden with all zero or null values in MicroStrategy 10.9 through 10.11, reverted in 11.0

2019

2019

DE118648

Data

KB482992: With Data Engine Version=11 or later, behavior is changed for equality between double type and zero

2019

2019

DE111407

CSI, Data

KB483550: Smart Derived Metric based on AFB Metrics end up empty

2019

2019

DE72791

Data, SQL

KB483566 - Wrong data is observed when multiple elements are selected for the same SAP HANA input parameter

2019

2019

DE121816

CSI, Data

KB483547: Error or no data returned in a visualization using a table with duplicate rows and no aggregation

N/A

2019

DE89990

CSI

KB441547: New optimized sql in MicroStrategy 11.0 for Multi-Table Data Import (MTDI) cubes with multiple join paths between two or more One-to-Many relationship tables.

2019

2019

DE123940

CSI, Data

KB482993: With Data Engine Version=11, visualization returns no data when the filter used in derived metric needs to be calculated in Data Blending step and it fails to select required attribute in intermediate CSI pass

2019

2019 Update 1

DE124440

CSI, Data

KB483532: Incorrect values for subtotal from base metrics with no facts

2019

2019 Update 1

DE123943

CSI, Data

KB483542: Metric Guide does not work for Count metric when used in a Compound metric

2019

2019 Update 1

DE123584

CSI, Data

KB483524: Wrong fact table is picked for join when the relationship between attributes is well defined in Connect Live datasets

2019

2019 Update 1

DE121750

Data, CSI

KB483562: Ambiguous source for attribute and metric lead to missing data when table with zero row picked

2019

2019 Update 1

DE95128

Data

KB483782: Group or New Derived Element with "Exclude" filtering starts showing data instead of empty grid

N/A

2019

DE147559

Data, CSI

KB483764: Calculations changed after upgrading from 10.4 to MSTR 2019

N/A

2019 Update 4

DE139854

Data, CSi

KB484037: For data blended dossier, a level metric's dimensionality is ignored

2019

2019 Update 3

DE149083

Data, CSI

KB484098: No data returned for multi-level metric defined on attributes

2019

2019 Update 4

DE124229

Data, CSI

KB483612: An Attribute Filter Is Not Applied For A Conditional Metric

2019

2019 Update 1

DE133759

Data

KB483641: Wrong metric level for metric with function causing 2 layers of level during double aggregations

2019

2019 Update 4

DE155272

Data

KB484032: Unspecified error caused by an aggregate from base (AFB) metric defined by Sum(Case(Clause, Max(attr), 0)) in MicroStrategy 2019

2019

2019 Update 5



KB442650

Comment

0 comments

Details

Knowledge Article

Published:

March 21, 2024

Last Updated:

March 21, 2024