2 Replies Latest reply: Jun 16, 2014 4:38 AM by bi007 RSS

    Duplicate data

    Ysaki

      Hey Everyone

       

      I am facing an unexpected output from the OBIEE side.   here is a link with pictures of both outputs

       

       

      https://drive.google.com/#folders/0B9A75PEOrs1ZUEtHSTJWYUN6LU0

       

      when i run the the report on SQL, the output is like this

       

       

      Item Number                           Description                         Category                         Location                  Quantity

       

      x                                                 black ball                       Soccer                            Ca-LA                           100

      x                                                 black ball                   Soccer                              Ca-SF                       100

      x                                                 black ball                       Soccer                            NV                           100

      x                                                 black ball                       Soccer                            NY                           100

      x                                                 black ball                       Soccer                            Ca                           200

      x                                                 black ball                       Soccer                            Ca                           100

       

       

      Meanwhile the output should be

       

       

      Item Number                           Description                         Category                         Location                  Quantity

       

      x                                                 black ball                       Soccer                            Ca-LA                        200

      x                                                 black ball                   Soccer                              Ca-SF                      200

      x                                                 black ball                       Soccer                            NV                           100

      x                                                 black ball                       Soccer                            NY                           100

      x                                                 black ball                       Soccer                            Ca                           200

      x                                                 black ball                       Soccer                            Ca                           100

       

       

       

      so its not showing me the Quantity the summed one based on the upper level which is the category, how can i make it show the exact output format like the SQL ?

       

       

       

      Your help is much appreciated since i have been trying to solve it for a couple of days now

       

      Thanks

        • 1. Re: Duplicate data
          K N Yadav

          Try using Sum( measure by column) forumula for your measure column. For example if you want to get the quantity sumed up by Category column then your formula for quantity column should be Sum( Quantity by Category).

           

          Hope this will help you to acheive your desired output. Mark helpfull/ correct as per your findings.

           

          Thaks,

          -Kashi

          • 2. Re: Duplicate data
            bi007

            Set aggregation rule either in RPD or at report level..

             

            Thanks

            Aj