KB18067: How to define an advanced qualification using a custom expression to filter on months in MicroStrategy Developer 9.x

The steps below demonstrate how to create a filter that qualifies on months prior to the current month using a custom expression in an advanced qualification in Strategy Developer 9.x:
 

• Open the Filter Editor to define a new filter.
• Double-click on the filter definition window to add a qualification.
• Choose the 'Add an advanced qualification' option and click on the 'OK' button, as shown below:
  

• By default, 'Custom Expression' is the option selected for a new advanced qualification.
• Enter the following expression:
  ApplyComparison("{Current Month} > #0", Month@ID )
  
• {Current Month} is the warehouse database vendor specific syntax to determine the current month in the appropriate format.
   
  The illustration below uses Oracle syntax.
   
  Validate the expression by clicking on 'Validate'
   
  

• Click the 'OK' button to complete the qualification.
• Click the 'Save and Close' button in the Filter Editor toolbar.