Hi @olammas,
In this case, you can leverage our with_relationships() function to define the metric that requires the disabled relationship path.
For more information, please refer to our documentation here with_relationships | Holistics Docs.
Basically, you can disable the relationship from the Dim model to 1 of your Event Table (let’s call it A).
And when you need to build metric that require the join from Dim Model to the Event Table A, you can use with_relationships() function to force enable that relationship within the context of your Metric.
sum(event_a.revenue) |
with_relatonships(event_a.join_key > dim_model.join_key)
If the with_relationships() function doesn’t make sense to your case, please let me know.