Multi-Fact Relationships

A multi-fact model is when you want to analyze metrics that originate from two different fact datasets. This is possible in AtScale, provided that both fact datasets have relationships to common dimensions.

For example, suppose you had two different events you wanted to analyze: web sales and store sales. You could analyze metrics from both fact datasets over the dimensions they have in common (customer, date, or vendor). However, you could not analyze store sales by the device dimension - this would cause an error at query time.

A multi-fact model is achieved by creating a one-to-many relationship between the common dimensions and each fact dataset.