Categories
Export Data To Excel From OBIEE Report

Hi,
I have to export a report/dashboard in excel which containing around 40k rows. I tried with simple "Export to Excel" option but only 2500 rows exported, I want to export all rows at a time. Please support.
Thanks,
Sami
Answers
-
Hi,
Did you try searching the forum, the doc and even just Google?
It's one of the most asked questions and the answer is always the same ...
0 -
Hi 3703993,
To add to Gianni's point, you should also provide some information about your environment/instance. At the very least ... your version. Assuming you are on 11g, try reviewing this note (which also contains links to the product documentation):
OBIEE 11g: Error: "Exceeded configured maximum number of allowed input records. Error Codes: EKMT3FK5:OI2DL65" when Exporting or Opening a Large Report (Doc ID 1487839.1)
Charles
0 -
I had the same issue, googled and found this article. Implemented it and it works.
https://www.clearpeaks.com/obiee-12c-export-to-excel-issue/
You will need to adjust your max number of rows based on how much your obiee environment can handle and consider/monitor whether it would impact your environment's performance if you have multiple users exporting huge amount of data from obiee. It took my environment a long time (6 mins) to export 200k+ rows with 17 cols. Based on the settings on the article, you're suppose to be able to export 900k+ rows.
0 -
As one recent Newbie to another, do do the following; -
Search the forum for your issue first, a lot of people have asked a lot of questions, yours may just be one of them
Do provide exact version of OBIEE
Do change your default display name, a lot of people ignore newbies
Do provide comprehensive concise detail of your issue
Do say what you have already tried
Do mark any answers you get correct / helpful, or if you get none of either then close your close with Assumed Answered
And don't assume you have a right to an answer, everyone here is doing this for no monetary recompense...
0 -
user12857001 wrote:[...] and it works.
WHAT works?
user12857001 wrote: Based on the settings on the article, you're suppose to be able to export 900k+ rows.
Not really. That's the problem when you just copy stuff from a blog without bothering to understand what is being done. If you touch the instanceconfig (and other files) for those setting you have to actually know what you are trying to achieve. Plus the example only covers tabular views.
The DOCUMENTATION is the key part one needs to read and comprehend:
0 -
Thanks for the tips, appreciate it. My default username won't change...sigh. I've updated it few times now and it is still the number userid...
0 -
Christian, with the settings in the article above, I could export over 200k+ rows with table view. Before I couldn't export past 20,000 rows. I haven't try exporting past 900k rows because my environment couldn't handle that much export that is why I said supposed. I totally agree with you, read the oracle documentations first and understand what is being done before touching those config files.
0