Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Export Data To Excel From OBIEE Report

Received Response
461
Views
7
Comments
Rank 1 - Community Starter

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

Welcome!

It looks like you're new here. Sign in or register to get started.

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 ...

  • Rank 6 - Analytics Lead

    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

  • Rank 1 - Community Starter

    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.

  • Rank 5 - Community Champion

    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...

  • Rank 2 - Community Beginner
    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

  • Rank 1 - Community Starter

    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...

  • Rank 1 - Community Starter

    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.

Welcome!

It looks like you're new here. Sign in or register to get started.