KB4665: How to create a report filter that results in a custom sub-query in MicroStrategy 9.4.x and 10.x?

EXAMPLE:
Users desire the ability to take a list of attribute element IDs from an end user (possibly multiple) without having to create a filter by individually selecting each element. The list can then be imported into a new warehouse table with a filter created to include the preferred list of Attribute elements.

• Create a filter using the Advanced Qualification:
   
  

• Through the use of the ApplyComparison function, create a custom expression filter to select the desired rows from the desired table. The ApplyComparison function allows users to bypass the Strategy SQL parser and create an expression where comparison operators (e.g., >, =, Like, In, etc.) can be used. For more information on how to use the ApplyComparison function, please reference KB5700-007-0107.
   
  

• Select 'OK', save and exit the filter.
• For this example, select ITEM_IDs from a table in the ItemUserA warehouse. The table appears as follows:
   
  

• Create a report that uses the following filter:
   
  

• SQL for the report above appears as follows:
   
  

•  
  NOTE: The sub-query has now been added to the where clause.
   
  
• The resulting report appears as follows: