Data Modelling

[A454A]

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?

[v-sshirivolu]

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

[cengizhanarslan]

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.