KB45117: View filter does not work correctly in an intelligent cube report with nested derived metric when "Aggregate from base" is enabled in MicroStrategy Web

SYMPTOM:
View filter does not work correctly in an intelligent cube report with nested derived metric when "Aggregate from base" is enabled in Strategy Web.
 
The following steps demonstrate how to reproduce the issue in tutorial project:
 

 
M1=Count<Distinct=True , UseLookupForAttributes=False >(Category){~+}
 

 
M2=Sum((Revenue - Cost)){~}
 

 
 
M3=Sum(M2 / M1){~}
 
 

1. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns.
2. Create an intelligent cube report with Year and three derived metrics and enable "Aggregate from base" as shown below:
3. Insert view filter "Year in list (2009)". The view filter cannot filter out other elements as shown below:

 
CAUSE:
This is a known issue in Strategy Web.
 
ACTION:
Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled Strategy release. 
 
WORKAROUND:
Change formula of M2 and add character "+" as shown below:
M2=Sum((Revenue - Cost)){~+}