KB42445: How to apply threshold on rows without specific characters in attribute element names in a report with compound metrics in MicroStrategy Developer?

In some business scenarios, it is required to apply threshold on rows without specific characters in attribute element names in a report with compound metrics in Strategy Developer.
 
The following steps demonstrate how to design this kind of report in Strategy Tutorial project as shown below:
 

1. Create two compound metrics C_R=Cost/Revenue and C_R_PM=C_R/.
2. Create a filter “Category do not end with c” with definition below:

 
This filter will filter out Category elements with character “c” in names.
 

• Copy metric “Cost” to “Cost(1)” . Modify Cost(1) and add filter “Category do not end with c” into condition as shown below:

• Create two compound metrics C1_R=Cost(1)/Revenue and C1_R_PM=C1_R/. Create a report as shown below:

• When Category=Music, the Cost(1) and C1_R_M will have null values. So the row for Music will not display in the grid. To enable this row display, change the Join type to “Join 92” and disable “null check” for metric in report VLDB properties. Set the metric “C1_R_PM” as outer join in Report Data Options as shown below:

• Change the report VLDB properties and set “False” for “Null checking for Analytical Engine” as shown below:

• Add threshold which qualifies on Rank of “C1_R_PM” as shown below:

• Analytical Engine will first exclude category elements with name ending with “c” due to null value, and then, apply threshold on rows at Movies and Electronics as shown below:

 
If directly ranking on C_R_M, rows at Movies and Music will display red. This way can make threshold applied only on rows without character 'c' in attribute element names.