So after completing the advanced data modelling concepts.
I have imported some tables from SQL and I am still hitting a brick wall on certain more specifc topics around advanced modelling - especially on M2M relationship.
If someone can please give me some direction If my model is on right path.
Layer 4 of my model is what cocnfuses my mind the most!
So I cannot link layer 4 directly into my fact tables I have many “Product-ID”). What I have done instead is consolidated all unique “Product-ID” into 1 "Master Product ID (Layer 3) table, using it as a Supporting Table.(2nd Screen Shot )
*(3rd Screen Shot) Not sure where I am going wrong? I know it meant to be 1-2-M Model, but in this specifc instance I get static numbers or really odd numbers when i report from “Product Cost History”. If i turn the relatinship to a “Single filtering” the number becomes static.