Hello all,
I am having an issue with my universe and could greatly use your help.
I created the universe as below, however when you include gross sales and off invoice discount in a report, it will duplicate the gross sales whenever there is an off invoice discount.
Your assistance is greatly appreciated =)
spiike32 (BOB member since 2010-11-15)
Welcome to B:bob:B!
What is the cardinality of the join between FactSales table and FactOffInvoice table?
Very likely you are experiencing so called fan trap. Here is the explanation of the fan trap and how to resolve it:
Use search to find more topics that discuss the same problem. There should be many.
Marek Chladny 
(BOB member since 2003-11-27)