adding a one to many related table to a fact table
I need some advise on how to model , data warehouse using a one to many relationship without having the wrong aggregation values when it is put in a cube. My problem is I have a fact and the business wants to add to it that has many records for that fact. For instance, a fact record that makes it unique has another table that has multiple records related to that fact record. How would I add the many table to my fact where I won't have inaccurate aggregated vales when aggregated? I thank you for any answer you may be able to provide.