The model
Eight conformed dimensions (date, category, department, group, priority, site, status, technician) and eight fact tables across every module — requests, request status changes, changes, problems, projects, assets, tasks, worklogs. One semantic model, named MESDP-Fabric-DPS, powers every report tier.