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

KB484910: Fix visualization failure issue when it contains multiple smart metrics from different datasets using same base metric with Data Engine Version 2021


Min Zhao

Quality Engineer, Principal • MicroStrategy


This article explains a failure fix when the visualization contains multiple smart metrics from different datasets using same base metric with Data Engine Version 2021

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.
Steps to Reproduce
This procedure is using Strategy Tutorial WH that is shipped with Strategy products.

  1. Login Strategy Developer, create Smart Metric M1 with expression: (Cost + 2)
ka0PW0000001JfWYAU_0EM4W0000026x78.png
  1. Create Smart Metric M2 with expression: (Cost - 2)
  2. Create Intelligent Cube C1 with: Attribute Year and Metric Cost, M1
  3. Create Intelligent Cube C2 with: Attribute Year and Metric Cost, M2
  4. Login Strategy Web, create dossier with C1 and C2 as datasets
  5. Add into Visualization: M1 and M2, error shows up.
ka0PW0000001JfWYAU_0EM4W0000026x79.png
  1. When viewing DSSErrors.log, “Duplicated Metrics Found” shows in the error message.

2021-03-18 13:54:11.106-04:00 [HOST:IP-0AF417C3][SERVER:T2188_IP-0AF417C3_210318102810307_4504_0001_sujuvu][PID:4892][THR:4836][Dimensional Storage][Error][0x80042408][UID:54F3D26011D2896560009A8E67019608][SID:AC69E7CEB926A7DB30C5D45AEED0EB95][OID:C93C809841506162EFAEFDBF495FC219][CDSSXTabMetrics.cpp:put_MetricIDsC at line:1296] Report request rejected by Analytical Engine. Report template is invalid.  Please check the definition of the report[ Duplicated Metrics Found]
Cause
This is a known issue in Strategy.
 
Solution
This issue has been addressed in Strategy 2021.
To pick up the fix, upgrade to Strategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. For more details on enabling the setting, refer to Change Data Engine Version.
After the fix, the Visualization returns data.

ka0PW0000001JfWYAU_0EM4W0000026x7A.png

Strategy internal reference number for this technical note is DE166446.
 


Comment

0 comments

Details

Knowledge Article

Published:

March 4, 2021

Last Updated:

March 21, 2024