Metadata-based reports generated in version 4.8 produce different results in version 5.x

Pentaho Metadata Editor

Version
9.5.x
Audience
anonymous
Part Number
MK-95PDIA007-02
In version 5.0 of the software, inner joins are resolved before outer joins by default. If you are migrating a report from version 4.8 to 5.x, you can specify which method to use by setting the legacy_join_order parameter in the report’s .xmi file.
  • 4.8 method: Set legacy_join_order to: true
  • 5.0 method: Set legacy_join_order to: false

In addition to setting the legacy_join_order parameter, set the Join Order Key field in the Relationship Properties window.