To force conditions that would ordinarily be processed in the JOIN condition to be processed in the WHERE clause, follow the directions below to create a delay_outer_join_conditions custom property.
- Right-click on a business model and select Edit.
- Add a property by clicking the green + icon.
- Select Add a Custom Property and set its ID to delay_outer_join_conditions and select boolean for the Type, then click OK.
- Select the newly-created delay_outer_join_conditions property, then click the checkbox for delay_outer_join_conditions under the Custom heading on the right side of the window, then click OK.
Instead of the conditions being rolled into the JOIN clause, they will be allowed to roll down into the WHERE clause.