Forum Discussion
How to resolve ambiguous relationship
Hello Konrad,
The issue here is due to the double sided crossfilter directions.As an example,
If you place a filter on IBC_Item_BOM_List it it will filter RPT_Warranty_and_sold.
If RPT_Warranty_and_sold is filtered it will then filter Sourcing_mart dim.
Sourcing_mart dim will then filter Claim_Master_View.
And finally Claim_Master_View filters IBC_Item_BOM_List.
So the result is that placing a filter on IBC_Item_BOM_List creates a situation where the tables tries to filter itself, which doesn't work too well.
If you change the direction of the crossfilter so that they are one-sided you should be able to create the relationship.
Br,
Johannes
Hello Konrad,
The issue here is due to the double sided crossfilter directions.
As an example,
If you place a filter on IBC_Item_BOM_List it it will filter RPT_Warranty_and_sold.
If RPT_Warranty_and_sold is filtered it will then filter Sourcing_mart dim.
Sourcing_mart dim will then filter Claim_Master_View.
And finally Claim_Master_View filters IBC_Item_BOM_List.
So the result is that placing a filter on IBC_Item_BOM_List creates a situation where the tables tries to filter itself, which doesn't work too well.
If you change the direction of the crossfilter so that they are one-sided you should be able to create the relationship.
Br,
Johannes
Thank you Johannes!
It worked.
When I changed the filter direction (to single), I consistently used "Index table filters Transaction table". (not sure what impact the direction has, but I am happy:-))
