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.
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
