KB40995: A derived metric returns blank values when it is defined with CASE or IF function having mixed data types in MicroStrategy Analytical Engine 9.4.x

SYMPTOM:
In Strategy Analytical Engine 9.4.x, a derived metric returns blank values when it is defined with CASE or IF function having mixed data types.
 
STEPS TO REPRODUCE:
Follow the steps below to reproduce the issue with Strategy Tutorial project:

• In Strategy Developer, create a metric like the below and name it as "CategoryM":
  Max(Category@DESC) {~+}
   
  
• Create a derived metric with CASE function having mixed data types like this, and name it as “CaseMetric”:
  Case((Revenue > 3000000), CategoryM, (Revenue < 3000000), Revenue, 0)
   
  
• Create a new report with the attribute Category in the row, and the metrics Revenue, CategoryM and CaseMetric in the column.
• Execute the report, and note that CaseMetric shows blank, as shown below:
   
  

• NOTE: The same issue happens when changing Case function to IF function in metric definition.
  

CAUSE:
This is a known issue in Strategy Analytical Engine 9.x.
 
ACTION: 
This has been addressed in Strategy 10. Upgrade to take advantage of the fix.