Categories
Setup for row limit when download results to CSV

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.
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
-
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.
0