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.
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
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
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
