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

KB298312: Subtotal of a compound metric doesn’t show correctly in Visual Insight in MicroStrategy Web


Community Admin

• Strategy


Subtotal of a compound metric doesn’t show correctly in Visual Insight in MicroStrategy Web

SYMPTOM:
Subtotal of a compound metric doesn’t show correctly in Visual Insight in Strategy Web 10.0, although Smart Metric has been enabled. Subtotal of the same metric returns correctly in report.
 
STEPS TO REPRODUCE:                                                 

  • Create a new compound metric in Tutorial in Strategy 10.0: Profit/Revenue. Enable smart metric for the metric.
  • Create a report containing the new metric. Add a compound attribute, For instance "Seasons", to Page-by and enable subtotal for the report.
  • Edit the evaluation order for the report: set Total to 1, metric "Profit/Revenue" to 2 and Seasons to Default.
ka04W000000OfudQAC_0EM4400000025Uv.jpeg
  • Run the report and the subtotal of Profit/Revenue shows correctly in the report. 

ka04W000000OfudQAC_0EM4400000025Ut.jpeg
  • Create a dashboard based on the report and subtotal for the metric Profit/Revenue returns an incorrect value in the grid visualization.

ka04W000000OfudQAC_0EM4400000025Ux.jpeg

 
CAUSE:
This is a known issue of Strategy Web 10.0.
 
ACTION:
Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled Strategy release.
Please contact Strategy Technical support for update on this issue.


Comment

0 comments

Details

Knowledge Article

Published:

June 13, 2017

Last Updated:

June 13, 2017