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

KB41672: How to create a report with a null column using metrics that are not based on facts in MicroStrategy?


Community Admin

• Strategy


How to create a report with a null column using metrics that are not based on facts in MicroStrategy?

Symptom:
 
The user would like to create a report with a metric that has an empty column. The user will then put data into the empty column using transaction services. When the user tries to create a report with a metric that is not based on a fact, the user an error message when executing the report.
 
Steps to Reproduce:
 
1. Create a metric that is defined as First("")
 
2. Add this metric to a report and try to execute the report
 
3. The report returns the error message that at least one fact is required in the metric definition as seen below:
 

ka04W000000uGELQA2_0EM440000002D4Z.png

 
Action: 
 
1. Create a metric that is defined as ZerotoNull(Sum(0){~})
 

ka04W000000uGELQA2_0EM440000002D4X.png

 
2. Add this metric to a report with an attribute. Run the report
 
 
3. The report will run without an error and return a null column for the metric as seen below:
 

ka04W000000uGELQA2_0EM440000002D4c.png


KB41672


Comment

0 comments

Details

Knowledge Article

Published:

June 7, 2017

Last Updated:

December 30, 2018