Forum Discussion
Data Modelling
Previously I had a nice star schema type of relationships as per the above image.
Now I have to add a new table Master_Table as per below to generate the below table.
Which means I am not using middle Dimension Table in my Matrix. Will this give me accurate results?
1-to-many relationships
-
Master_Table[M_Code] → Dimension[Star_Code]
-
Dimension[Star_Code] → T1/T2/T3
Single-direction filtering
-
From Master → Dimension → Facts
-
No bi-directional shortcuts
Grain is respected
-
Each M_Code maps deterministically to Star_Code(s)
-
No ambiguous many-to-many paths
If these are met, the Dimension table still acts as the logical bridge.
-
3 Replies
1-to-many relationships
-
Master_Table[M_Code] → Dimension[Star_Code]
-
Dimension[Star_Code] → T1/T2/T3
Single-direction filtering
-
From Master → Dimension → Facts
-
No bi-directional shortcuts
Grain is respected
-
Each M_Code maps deterministically to Star_Code(s)
-
No ambiguous many-to-many paths
If these are met, the Dimension table still acts as the logical bridge.
-
Hi A454A ,
I would also take a moment to thank cengizhanarslan ,for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions
Hi A454A ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
