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

    resolve synthetic keys

    Hans kleijnen

      Dear

      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?