14 Replies Latest reply: May 17, 2017 2:11 AM by Hans kleijnen RSS

    resolve synthetic keys

    Hans kleijnen


      Please see attached

      I want to show in 1 QV document actuals versus budget. Actuals separately works, Budget separately works, Combining Actuals and Budget creates synthetic keys and does not work properly. I have tried to resolve by qualifying. However unqualifying to much leads to the same problem.


      unqualifying for example ACCT_NO, results in budget data only up to the month of uploaded actuals.


      I need to see reports by (at least) Entity, by ACCT and by Date.


      Who can support me?