Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Setup for row limit when download results to CSV

Received Response
497
Views
2
Comments
aPsikus
aPsikus Rank 6 - Analytics Lead

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.

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Take a look at this thread from yesterday although I would strongly suggest that a row limit of 1000000 is a bit excessive and I would think a discussion about the actual requirement might be something that needs to happen.

  • aPsikus
    aPsikus Rank 6 - Analytics Lead

    Hi,

    Thanks for the link.

    I'm afraid that one of us didn't get the point.

    I had error message displayed as set of data to export was bigger then set limit.

    I have expanded the limits.

    Error message is not displayed any more, but I want it back if set of data is bigger that set limit.

    Now I have behavior that set is limited to set limit, but there is more data which are not downloaded and I'm not informed.

    For me article is not about my problem.