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

Take a back up copy of instanceconfig.xml file.

Open instanceconfig.xml for editing.

Increase the value of the parameter DefaultRowsDisplayedInDownloadCSV to an appropriate amount. For example:

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.

Startup:

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.

Content:

New content is highlighted with light-blue:

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

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:

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

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

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 11.1.1.7 – then this might be useful.

There was a slight confusion and error messages when installing OBIA 7.9.6.4 on OBIEE 11.1.1.7.0
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 11.1.1.7) – 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.)

I hope I’m not preaching to the preachers, but to me it’s obvious that some Linux skills are a must for OBIEE consultants. As well as virtual machines (at least virtual box), serious networking skills, and Fusion middleware stack knowledge.

I suggest starting with Sample images and getting Oracle Linux skills through some tutorials.