4 Replies Latest reply on Oct 30, 2017 3:53 PM by Christian Berg

    How to increase rows return in OBIEE

    3319067

      HI all,

       

      Please let me know how to increase rows return in OBIEE.

      Please see the below sample code.

       

      WHERE

      ((("- Plan".Plan = 'None')

      ORDER BY 1, 2 ASC NULLS LAST, 3 ASC NULLS LAST

      FETCH FIRST 200007 ROWS ONLY

       

      The above logical query (part of query) returns 2 lakh records. I would like to increase this number. How to increase this?

       

      Second question:

       

      I have a seeded repository and i have done changes to this repository. How to find changes to the seeded repository (what are the changes done to seeded repository?)?

       

      Regards,

      Chandra.