Level 7 - ArchitectScenario-Based Questionsm4 dimensional performance models
Scenario: Semantic Layer and SQL Performance
Your semantic layer generates verbose SQL with repeated joins. Propose approach to keep analyst freedom but improve performance.
Schema Context
fact tables + shared conformed dimensions