KB16266: The report’s filter is ignored in MicroStrategy Developer 9.x

SYMPTOM:
When users run a report using a simple filter, the filter is not applied to the report in Strategy Developer 9.x. The results returned to the users are not filtered as expected. The report SQL indicates that the filter has not been applied to the report as expected.
 
CAUSE:
The Strategy 9.x Engine is ignoring the conditionality at the report level because a metric in the report has conditionality.
 
The metric has been set to ignore the filtering criteria that have been specified.
 
ACTION:
To resolve this issue, users must follow the steps below:
 

• If the report's and metric's filter affect attributes from the same hierarchy, check that the following setting is un-checked:
  

•  
  This setting is placed in the metric editor, condition section, advanced button.
   
  
• If the metrics have dimensionality assigned, ensure that the metrics are not set to ignore the filtering criteria in the dimensionality section of the metric editor, as shown below:
  

•  
  Ensure that the filtering for the filtered attribute is NOT set to ignore.
   
  

Strategy will ignore all the unrelated filters for the metric calculation. If a fact does not exist at a certain level, the Strategy Engine will ignore that filter when calculating the aggregation for the fact. The Strategy Engine generated a cartesian join.
 
Further information regarding filtering reports in Strategy Developer 9.x can be found in Strategy Basic Reporting Guide Product Manual.