KB219862: 'Invalid Expression' error is encountered when 'INTERSECT' operator is used in Custom expression editor in MicroStrategy Developer 9.x.

SUMMARY:
This issue is classified as a defect with Strategy Developer 9.x. This will hinder users from using a filter that contains the 'Intersect' operator. When creating a filter that uses an 'Intersect' operator to compare and collect co-existing data between two or more attributes, an 'Invalid Expression' error occurs upon trying to validate the expression, making it impossible for the user to create a valid filter.
 
SYMPTOM:
 
When a user uses the 'INTERSECT' operator in a custom expression in the filter editor in Strategy 9.x, the Qualification editor presents an 'Invalid Expression' error and does not validate the custom expression function.
 

 
STEPS TO REPRODUCE:
 

• In Strategy Tutorial, navigate to Public Objects > Filters > Market Basket Analysis Filters and edit the filter named 'Orders with Item A and B'.
  

• Double click on the Qualification to edit the Set Qualification.
  

• Click 'Modify' to pen the Qualification Editor.
  

• Double click on the expression to open the Advanced Qualification/Custom Expression Editor.

• Click 'Validate' and 'Invalid Expression' error is encountered.
  

 
CAUSE:
 
This is a known issue in Strategy Developer 9.x.
 
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.
 
The Strategy Internal Reference Number for the issue discussed in this technical note is 976886.