2 Replies Latest reply on Apr 8, 2015 10:07 AM by asim cholas

    Table View: Need help for expected data display in reports while GROUP BY

    2753252

      Hi Gurus,

      Table View: Need help for expected data display in reports while GROUP BY

       

      Data Display in Database:

       

       

       

      When we apply group by in Report:

       

      Expect Result:

       

      The unit number should display once for each description in group2.

       

      Actually Result:

      It display duplicated unit number in group2.

       

      Can any one help on this, Is it feasible in OBIEE 11g?

       

      ***********************************************************************************************************************************************************************************************************

      Hi Gurus,

       

      However in OBIEE it is required to show data in a period of time, for e.g. one month like this:

      CR38126(1).jpg

      Then it merges up some duplicated data “1,1,2”, which is joint from two pieces “1”+”1,2” falls in the one month period.


      Thanks,

      Sri