Is there a healthy way to bridge a link between a fact-dimension, where their relationship is only partial?
Bridging the Gap Connecting Partial Dimensions to Measures in Data Analysis Data analysis often involves building relationships between dimensions and measures