KB17415: How to remove the COALESCE function from the report SQL generated in MicroStrategy

The COALESCE function is most commonly utilized by the Strategy SQL Engine to support and maintain the data consistency in full outer join results. More information regarding the COALESCE function is described in detail in the following Strategy Knowledge Base article:
KB7348 : What is the ’COALESCE’ function in SQL, and how does the Strategy SQL Generation Engine use it?
 
To remove the COALESCE function from the SQL generated by the Strategy SQL Engine, perform one of the following actions:

• At the project level, change the VLDB property 'Full Outer Join Support' to 'No support' from the Database Instance's VLDB properties under the 'Joins' group.
  OR
  
• At the report level, change the VLDB property 'Full Outer Join Support' to 'No support' from the Report > Data > VLDB properties under the 'Joins' group, as shown below: