Forum Discussion
Helper IIRelationship Filtering Error Question
Helper IIThe error occurs during the relationship definition and setting the filtering to BOTH.
There is a relationship between Calenar and the Invoiced Sales Orders table based on date. However, the part that I'm not clear on is why this is impacting the relationship between Sales Person and the Invoiced Sales Orders table.
My thinking was that if I set filtering to BOTH on the relationship between Sales Persons and Invoiced Sales Orders table, when I filtered a specific sales person those assocaited transactions would follow (and yes calendar dates).
I understand there is a relationship between the Invoiced Sales Orders table and Calendar table based on date, but still do not follow why this interferes with a BOTH filter on the Sales Person and Invoiced Sales Orders.
Promethes_2 could you post your data model so we can help investigate further? I'm not able to see any error from your screenshot.
- Promethes_2
Apologies I wasn't more clear.
When I try to change the existing filter direction in the relationship on any of the following relationsihps from the 2nd screenshot:
Invoiced Sales Orders and Sales Person single -- If i change to BOTH filter direction no error
Invoiced Service Orders and Sales Person single -- If I also change to both ERROR occurs (1st screenshot)
Open Sales Orders and Sales Person single
Open Service Orders and Sales Person single
From a SINGLE cros filter direction to a BOTH cross filter direction the 1st screen shot error occurs. I can change one of the relationships listed above to BOTH, but I cannot change all four to BOTH (the error occurs when I try to change to BOTH on the second relationship).
I'm really just interested in learning the why. Thanks!