Forum Discussion

schilders's avatar
schilders
Icon for Helper I rankHelper I
1 year ago

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...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
1 year ago

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?

  • schilders's avatar
    schilders
    Icon for Helper I rankHelper I
    1 year ago

    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.