System-generated aggregates will include joins by enabling the engine's advanced setting `aggregates.create.joins.enabled` parameter.
- Log into Design Center UI as an admin user
- Navigate to SETTINGS--> Engine --> Advanced Settings
- Search and enable "aggregates.create.joins.enabled"
- No engine restart is needed.