Forum Discussion
Solved
Data model
Hello! I have a question to know which is the best practice. I have a project where I have 4 tables: -Program (IdProgram,Name,Responsable...) -Parts of the program (IdProgram,IdSection,Secti...
Best practices suggest creating dimension tables with unique values for fields common to different tables, creating one-to-many (single direction) relationships between these dimension tables and the corresponding fields in the fact tables.
you then use the diemnsion table fields in measures, slicers, visuals, filters...
The dimension tables provide the filter context for correct filtering and calculations
katybr Hi, I don't have much details about your model, but it's depend on each table's complexity and weight. Also I believe if you merge 4 queries in one, it wouldn't be good practice in term of query performance.