Forum Discussion

katybr's avatar
katybr
Frequent Visitor
4 years ago
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...
General Comment
Tips and Tricks
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    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

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

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