Oracle Analytics Cloud and Server

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

Export functionality

Received Response
1
Views
1
Comments
3150803
3150803 Rank 1 - Community Starter

I am a developer and use the Oracle BIEE for creating panels.

Recently I came across the malfunction option "export" of a particular analysis.

The option to export to an Excel file can not download all table record lines on display.

I could only export the table using the option to " delimited format for tabulation ."

Please if anyone has had this problem and have any option to correct the malfunction , share here.


Thanks

Answers

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Yeah first you have to go inside your OS that has the Oracle BI EE installed,

    go to the follow path:

    <Oracle BI Instance>/instance<N>/config/OracleBIJavaHostComponent/coreapplication_obijh1

    Edit the "config.xml" file:

    XMLJava.png

    Go Oracle Enterprise Manager

    OEM.png

    Go to the

    <Oracle BI Instance>/instance<N>/config/OracleBIPresentantionServiceComponent/coreapplication_obips1



    instanceconfig.png




    If you want information in more detail please visit this web site https://docs.oracle.com/cd/E29542_01/bi.1111/e10541/answersconfigset.htm#BIESG1705


    With this configuration you can download infinite download, in my case, my client sometime download 7 GB of data in excel.


    Kind Regards,