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


In OBIEE or, there was no specific parameter to limit download to CSV format but in OBIEE, 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–>
    <!–This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control–>
  4. Save your changes.
  5. Re-start OBIEE services.

Review of the OBIEE Sample App v506

Little background – starting several years ago, Oracle has started providing public with a virtual machine with an image of the whole OBIEE stack. I think this has enabled multiple people to jump into OBIEE world much quicker and focus on the tool. In pre-VM era, if you wanted to deploy OBIEE 11g, you had to spend a few hours preparing infrastructure and installing the stack with DB).  This is my review and impressions of the Sample App v506.

I must tell you, this is the best release of the machine so far – in many aspects, including easiness of installation, comprehensive documentation, examples of best practices and stability. So the short version is, spend some time downloading it – must have. This is a very brief overview – and I’ve not yet had a chance to review Big Data – however, the support for the Cloudier Impala is huge. I think the product team is moving in the right direction.

Installation and performance: 

Installing this on my MacBook pro was very straightforward. Download and unzip the files. Import the resulting ova file into the VirtualBox 4.3. Network Configuration was straightforward as well. I’ve used default NAT – so using localhost:7780/analytics as a point of entry . The machine comes with a very detailed document on how to configure VM networking. I’m running it from an external USB3 drive – but the responsiveness is pretty good, considering how much stuff is there. For optimal performance, I’d recommend having 16Gb of RAM and SSD – that makes everything go faster.


Once the VM is up. All you need to launch the demos is 1-click – literally – this hides a lot of complexity behind and allows you to quickly demo functionality / visualizations.

Sample app startup script


New content is highlighted with light-blue:

new content

Plenty of new charts and visualizations – targeting latest trends (Big Data analysis, HTML5, web API graphs). I really like the new functionality of being able to search the columns in Answers:


OBIEE search Answers
OBIEE search Answers


A lot of map features and examples – this is extremely useful for working on spatial analytics. Spatial analytics demos are very impressive and work smoothly, like the example below:

Screen Shot 2015-08-27 at 3.47.38 PM

This HTML5 chart is very impressive as well – there’s also an attached workshop on how to create such maps:

Airport Connections

Overall, the value of the content is very high. I see a lot of various applications – for BI consultants, developers, analysts, end-users.

I also want to use the occasion and thank the BITECH DEMO team!




Confusion with BI Apps when installing on OBIEE

If you have seen this error message “NQSConfig.INI not found. Please make sure your environment is set up properly” or were unable to login to OBIEE after installing OBIA 7964 on OBIEE – then this might be useful.

There was a slight confusion and error messages when installing OBIA on OBIEE
Unfortunately, there are several contradicting bugs and instructions – for instance – patch p16321623_7964_Generic would not work too well (the jazn file is not compatible with OBIEE – You need to search for the following item on the metalink:
ID 1561846.1 (first step includes running bi-init.cmd prior to setup and 2nd includes downloading proper system-jazn-data.xml file.)

This has worked for me.