Hi - what is the best way to manage 1:M relationships in my data model.
For example I have a Purchase order value in my fact table, but in my Authorizers dimension table I have two records for the same purchase order as two people have authorized the spend.
When i do a sum of Purchase Order Value across Authorizer the total value is doubled. Many Thanks Darrell.