KB428735: How to use an outer join to retrieve data when a metric on the report has a condition that is mutually exclusive with the report filter in MicroStrategy 10.x

A report defined as shown below returns no data in Strategy 10.x:
 
NOTE: Replace the metric 'Dollar Sales' with 'Revenue' in the Strategy Tutorial project. The discussions below are still valid even though the results may be different.
Metric 1: Dollar Sales
Metric 2: Dollar Sales with a condition (USA)
Report Filter: All non US countries
The report returns no data because by default, an inner join is performed on the metrics.
 
ACTION:
Define an outer join at the report level:
Go to Data Menu>Report Data Options>Join Type>change the setting to "outer".
 
Or
 
Define an outer join at the metric level:
Open the metric editor for the metric that is returning no data. Go to Tools Menu>Metric Join Type>check the radio box "Outer join".
 
The result:
 
If users wish to modify the field display for the empty cells, they should go to Data Menu>VLDB Properties.
 
The result:
KB428735