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

KB44486: How to inherit the "Smart Metric" option when building a compound metric in MicroStrategy?


Community Admin

• Strategy


This article describes how to setup metrics so that smart metric options are automatically inherited in MicroStrategy.

SYMPTOM:
 
In the Strategy Tutorial project, copy a smart metric and notice that the new metric is still a smart metric;
For example, right mouse click the metric “Discount %”, select Copy, Paste and notice it is smart metric enabled. 

ka04W000000OhopQAC_0EM440000002CGh.jpeg

 

  • However build a new metric, then drag in the original smart metric into the definition window and notice that the “allow smart metric” is greyed out.

For example, “test” is a smart metric defined same as “Discount %” with the definition of "(Discount / Revenue)". Build a new metric called “New Metric”, and put the test in the formula definition, and notice the smart metric is grayed out. 
 

ka04W000000OhopQAC_0EM440000002CGk.jpeg

 

ka04W000000OhopQAC_0EM440000002CGj.png

 
CAUSE:
It’s the designed behavior that when a metric is defined by only one component, it will be non-smart metric. The “smart” means that Strategy SQL Engine will calculate the components separately and Analytical Engine will do the final calculation with the components. Therefore, “smart” is only meaningful for metric with multiple components. That’s why the checkbox for “smart” is grayed out if only one component is found in the metric expression.
 
ACTION:
According to current logic, if parent metric is set to be non-smart, all of its components will be calculated non-smartly.
 
WORKAROUND:
Define metric with multiple components, for example, define “D” as “C*1”, C is a smart metric.
In this way, Strategy Developer will validate the expression to find two compounds: ‘C’ and ‘1’, thus the “smart” checkbox will be enabled.


Comment

0 comments

Details

Knowledge Article

Published:

April 11, 2017

Last Updated:

April 11, 2017