Forum Discussion
Fact table with multiple dimension relationships
I'm struggling with what I think should be a straightforward concept, but I'm not a data scientist so maybe I'm approaching it wrong. I've manipulated our data into (what I think) is a clean stru...
Hi markca ,
For each of the dates (lead date, sale date, etc.) and user roles (lead agent, sales agent, etc.) in your fact table, you can create calculated columns in your dimension tables that fetch the relevant information based on the active relationship. This might involve using or functions. While this approach might seem cumbersome, it allows you to bring in the necessary context directly into your dimension tables, which can then be used in visuals without relying on
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.