Category Archives: Uncategorized

65000 rows CSV Limit – hidden parameter

I have spent 1,5 hours trying to figure this out. It seems as unnecessary item and a well-hidden one.  This is valid for OBIEE 12c as well.

You have upgraded your OBIEE 11g instance to OBIEE 11.1.1.9.0.
Now when you export reports to CSV format file, you do not get more than 65000 rows downloaded.
In earlier versions of OBIEE 11g, you could download more than 65000 rows.

CAUSE

In OBIEE 11.1.1.6.x or 11.1.1.7.x, there was no specific parameter to limit download to CSV format but in OBIEE 11.1.1.9, one can add DefaultRowsDisplayedInDownloadCSV parameter.

There is a need to add a parameter in instanceconfig.xml, called DefaultRowsDisplayedInDownloadCSV, with which you can control how many rows are downloaded to CSV format. By default, number of rows downloaded is 65000 rows.

The DefaultRowsDisplayedInDownloadCSV parameter needs to be added to instanceconfig.xml as it is not there in the standard one.  Customer could add it in case they need to download more than 65000 rows.

Proposed solution

  1. Take a back up copy of instanceconfig.xml file.
  2. Open instanceconfig.xml for editing.
  3. Increase the value of the parameter DefaultRowsDisplayedInDownloadCSV to an appropriate amount. For example:
    <Table><!–This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control–>
    <DefaultRowsDisplayedInDelivery>1000000</DefaultRowsDisplayedInDelivery>
    <!–This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control–>
    <DefaultRowsDisplayedInDownload>1000000</DefaultRowsDisplayedInDownload>
    <MaxCells>10000000</MaxCells>
    <MaxVisiblePages>50</MaxVisiblePages>
    <MaxVisibleRows>1000000</MaxVisibleRows>
    <MaxVisibleSections>100000</MaxVisibleSections>
    <DefaultRowsDisplayed>100</DefaultRowsDisplayed>
    <DefaultRowsDisplayedInDownloadCSV>100000</DefaultRowsDisplayedInDownloadCSV>
    </Table>
  4. Save your changes.
  5. Re-start OBIEE services.

New version of Sample Apps Released – SampleApp V305 (11.1.1.7)

New version of the OBIEE Sample App is now available for download. For those who might now know what this is – it’s a per-configured environment that’s ready to operate, so you don’t have to spend hours installing DB stack along with OBIEE -but could get straight to the point. Could be useful to those who have not seen it before and consider an upgrade, or those  who would want to learn OBIEE. Regardless – great job and definitely something to download and experiment with in case you work with OBIEE. Of course, the hardcore guys always install it themselves, but for others – it’s great. Well done, BIEE PM Group!

 

Link to download the Sample Apps OBIEE 11.1.1.7

 

Oracle Open World 2012

I’m going to Open World 2012. Actually waiting for the flight right now. I’m very excited, since it’s my first one. (for various reasons, I couldn’t make it in previous years)

I’m looking forward to meeting my fellow bloggers in person as well as everyone else. It seems as the focus this year is on Big Data. Thanks to everyone who shared tips and hints about attending.