2 Replies Latest reply on Oct 24, 2018 7:21 AM by aPsikus

    Setup for row limit when download results to CSV

    aPsikus

      I have requirement to expand number of rows when download report to CSV file in OBIEE 12c.

       

      As I have noticed it is set in two places:

      Enterprise Manager -> Business Inteligence -> biinstance -> Configuration -> Performance

      Maximum number of rows processed when rendering a table view option

       

      Oracle_Home/user_projects/domains/bi/config/fmwconfig/biconfig/OBIPS

      there is file instanceconfid.xml to which we need to add line:

      <DefaultRowsDisplayedInDownloadCSV>number of rows</DefaultRowsDisplayedInDownloadCSV>

       

      Setup looks like this:

      in EM number of rows is set as 140000

      in config file it is set as 300000

       

      When we export report to CSV, result is that file contains only 139801 lines (with headers) and at the bottom there is displayed error message that not all rows were exported.

      csv_error.JPG

       

      I was asked to expand limit to 1million rows.

       

      Currently in both places I have set 800k rows, but result is that CSV file contains 800001 rows (with headers), but error message is not displayed any more, and I do not know if all was exported or there are more rows.

       

      Please advice which setting is responsible for displaying error message in CSV file, or how these limits should be set to still receive error message when number of rows from report will exceed the limit.