Forum Discussion
Data Model Does Not Return Accurate Summary
I'm working with the data model as shown above. My intent was to design a star schema model. The Member Months object uses a Merge Key that concatenates several fields to achieve a primary ke...
schilders the one thing in the model I noticed is that you have cross-filter direction set to both for a few of the tables which is not a recommended/best practice. Could you change the filter direction to single for these relationships and then test the results?
parry2k Thanks for your response! I changed all filter directions to single. This grossly inflated the Member Months aggregate. Reverting back to Both between Member Months and Details restores my under-stated value.
This is an excellent point. I'm refactoring an older dashboard and its data model implemented cross filtering in both directions.
Please let me know if there are other changes I should attempt.
Appreciate your help and guidance.