Forum Discussion
smileamile2
5 years agoResolver I
Relationship causing aggregation at highest level
I have 3 tables: Budget, OS Acct Master, Acct Hierarchy, Actual. The relationship is below. Note there can be multiple ERP Accts to 1 OS Acct (which I think is what's causing the issue I'm seeing). B...
- 5 years ago
I actually took out the OS Acct Master table because it didnt' seem to actually be doing anything besides causing ambiguity. Now I have a many to many, but it works.
- 5 years ago
smileamile2 well in a larger model it is not recommended, it is a weak relationship, you should have tried changing the cross filter to both, would have worked. anyhow, just a recommendation.
If cross filter direction both worked, then you just simply added that in the measure and change the direction back to single, you would have a better data model rather these many to many
smileamile2
5 years agoResolver I
I actually took out the OS Acct Master table because it didnt' seem to actually be doing anything besides causing ambiguity. Now I have a many to many, but it works.