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

    Need suggestion over aggregation of records

    3521884

      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

      Abhi