I have a table that has all my Materials / Products information in it such Material number and name which are perfect for lookup tables. However it also contains some info which i will use to make some calculations such as goods received lead time and shipping lead times so how would you model this? would you place it on the top of model as a 1 to many lookup or place it on the bottom as fact table???
or do i split it in the query editor into relevant sections? else i would duplicate some fields which isnt nice optimizing.
Just wanted some advice