11 Replies Latest reply on Feb 15, 2019 11:08 AM by Robert Angel

    Need suggestion over aggregation of records


      Hello Experts,


      I need a suggestion regarding a requirement related to OBI.


      I have a requirement where

           - Against one user_ID there are two customer Name

           - Both are the name of same customer (some how in source system it has been entered).

           - In OBI actual report is looking like


      The requirement is

           - Create a single record with User_ID.

           - Name of the customer can be any (can be picked randomly out of three records).

            -Create a new column which will aggregate  against user_ID


      Can this be feasible in OBI.

      I tried to club it but due to different customer name it is always showing three records with total target.


      Kindly guide.

      Thanks for your help