CRITICAL
Rule Definition
Multiple SQL statements for each measure can negatively impact performance, although you may choose to enable this option during development since it may solve some fan trap situations.
Remediation
Turn the option off.
Reference
BO Best Practices for v5
Related Technologies
Technical Criterion
Efficiency - SQL and Data Handling Performance
About CAST Appmarq
CAST Appmarq is by far the biggest repository of data about real IT systems. It's built on thousands of analyzed applications, made of 35 different technologies, by over 300 business organizations across major verticals. It provides IT Leaders with factual key analytics to let them know if their applications are on track.