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

KB18024: Metric values are blank in a report, but the subtotal is displayed correct, when using 'Allow smart metric' totals on the metric in MicroStrategy Developer


Stefan Zepeda

Salesforce Solutions Architect • Strategy


A report displays blank metric values but the correct subtotal in MicroStrategy Developer.

SYMPTOM:
A report displays blank metric values but the correct subtotal in Strategy Developer, as shown below:
 

ka02R000000kZvaQAE_0EM440000002EtV.jpeg

 
STEPS TO REPRODUCE:
Follow the steps below to reproduce the issue using the Strategy Tutorial project:
 

  • Create a compound metric based on two metrics which contains a condition, as shown below:
ka02R000000kZvaQAE_0EM440000002EtJ.jpeg
  • Check 'Allow Smart Metric' under Subtotal/Aggregation tab as shown below:
ka02R000000kZvaQAE_0EM440000002Etb.jpeg

CAUSE:
The VLDB property Analytical Engine > 'Null checking for Analytical Engine' is set to 'False.'
 
ACTION:
Follow the steps below to resolve this issue:
 

  • Go Data > Report Data Option > VLDB properties as shown in the image below:
ka02R000000kZvaQAE_0EM440000002Eta.jpeg
  • Expand Analytical Engine, then highlight 'Null checking for Analytical Engine', and set it to 'True', as shown below:
ka02R000000kZvaQAE_0EM440000002EtA.jpeg
  • Save and close the VLDB Properties windows. The report will be automatically re-executed and the data will be displayed correctly as shown in the image below:
ka02R000000kZvaQAE_0EM440000002EtX.jpeg

Comment

0 comments

Details

Knowledge Article

Published:

June 2, 2017

Last Updated:

June 2, 2017