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
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 ...
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
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.
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...
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:
https://docs.oracle.com/middleware/12213/biee/BIESG/GUID-FF6954BA-2DE0-4422-BA58-05F32936F4FF.htm#BIESG1719
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...
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.
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…
Can you please help resolve this error. WebLogic version is 12c. OAS is 6.4
So I have an action passing a value to another workbook. On the other workbook, I have an expression filter and a parameter I created and it does not seem to work. Any ideas. See the images
We know you can directly export workbooks and folders from within OAC, and we know you can migrate OAC content using the FDI Content bundle. However, it's unclear what settings or steps are required in order to ensure any calculations in "Shared Objects" still carry over. When making a .dva artifact export from OAC for…
The user icon in the upper-right corner of OAC (DV) is displaying more menu options for our non-admin users than we wish to display. We would like to restrict these to only "Profile" and "Sign Out" for regular users. Is there a way to customize these menu items? Especially if we can control this via security, that would be…
What is wrong with this code
