KB37058: Filters with prompts cannot be added to hierarchies in the Hierarchy Editor and will display a warning message in MicroStrategy Developer 9.4.1 and 10.x: "Filters with prompts can not be added to hierarchies."

SYMPTOM:
In Strategy Developer 9.4.1 and 10.x, filters with prompts can not be added to hierarchies in the Hierarchy Editor. Users will encounter a message indicating that filters with prompts can't be added to hierarchies.
 
STEPS TO REPRODUCE:

• In Tutorial, create a new filter with the following syntax: ApplyComparison ("#0 in (select sdc_grp_id from dbo.v_rpt_user_roles where upper(bnk_nb_id) = upper(#1)) ", Region@ID, ?).
• Open a hierarchy and choose any attribute, Right Mouse Click -> Define Attribute Filters.
• Choose the filter you created in Step 1, the following error message be thrown:
   
  

• 
  Filters with prompts can not be added to hierarchies.

  
  
  
   
  

CAUSE:
This is a known limitation with Strategy Developer 9.4.1 and 10.x.  This type of operation is currently not supported in the Strategy platform.
 
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.