I'm designing a data warehouse and I keep reading that there should be no relations between fact tables.
I'm sure everyone here is well aware that businesses are full of facts which are inherently related to each other, so how is one supposed to represent these relationships without relations between fact tables?
To give just a couple of simple scenarios, what if I have refund facts which each relate to a purchase fact? Or if I have page view facts (a large volume of) a small percentage of which relate to error facts?