I have 3 fact tables:USA,JAPAN, UK
Each fact table has identical columns (item, quantity, price)
They are joined to multiple conformed dimensions (customer,company, products, time, etc.)
What I am wanting is a UNION ALL (sort of). I want price(fact) to be price for USA, JAPAN, and UK. I do not...