Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

When Exporting to Excel, number of rows gets reduced with an "X" logo (OBIEE 11.1.1.7.140715)

Received Response
1
Views
4
Comments
3156138
3156138 Rank 1 - Community Starter
edited Aug 13, 2024 7:08PM in Oracle Analytics Cloud and Server

Hi guys,

When I am doing exporting of data after having operated a query, I noticed a few errors.

The data comes out messed up like this; in OBIEE, I get 6,000 or so entries, but here, I only get 3,865, with a noticeable 'X' here. Can anyone advise on what has happened and how I can mitigate this?


Thanks!

Error.png

Answers

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

    If you want to download, unlimited row.

    Please,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.xml



    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




    Kind Regards,



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

    Please, remember Oracle BI is a web analytics system, if you want to show from bi analytics these 10 millions rows, you first could have a real good storage in your server and your client.

    In my experience, to show that huge amount of data it's no practical for to end users.

    However, Oracle as a BI Enterprise Platform, has two ways for your requirement:

    1. If you want to show by default, you have to set up your instanceconfig.xm, check this links (Configuring and Managing Analyses and Dashboards - 11g Release 1 (11.1.1)),

    which is in <Oracle BI Instance>/instance<N>/config/OracleBIPresentantionServiceComponent/coreapplication_obips1\instanceconfig.xml


    instconfg.png



    2. Or you could set up, in Oracle BI Presentation,

    Pivot Table

    PivotTableRows.png

    3, Table:

    TablesProperties.png

    Kind Regards,

  • 3156138
    3156138 Rank 1 - Community Starter

    Hi Cesar,

    Many thanks for the thorough explanation. Would I be right to say that this error is caused by too little heap size to export to Excel?

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

    Yes,when your export data it depends on two variables:

    - The setting of  InputStreamLimitInKB

    - The rows number which are download in Oracle Enterprise Manager.

    Setting it for your requirment.

    Kind Regards,