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

Why is it going slowly?

Received Response
31
Views
3
Comments
User_TML1V
User_TML1V Rank 2 - Community Beginner
edited Aug 13, 2024 5:57PM in Oracle Analytics Cloud and Server

Why is it going slowly?

When I use the export to excel function in OBIEE 12c, it goes slowly.

Does anyone have any tips on how to speed up the process?

I have looked at the server processor but it is in 95% idle. This is when the export is working at the hardest.

What can I do about it?

OBIEE_Export_EXCEL.jpg

OBIEE_Export.jpg

Answers

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Export to excel 2007+ makes use of BIP Libraries for export as it export report along with formatting present within the report henc it generally takes up more time to export than export to CSV where only data gets exported hence its faster.

    a) What is your exact OBIEE 12c Version is it 12.2.1.0.X , 12.2.1.1.X or 12.2.1.2.X, where X is bundle patch if applied in the environment?

    b) Is your export to excel 2007+ failing or its just taking to much time to export?

    c) Export to excel 2007+ depend on many factors and hence could be slower, for starters what are the Number of Rows and Columns ou are trying to export to Excel 2007+?

    d) To calculate approximate time for report export to Excel 2007+ you can use below formula

    Number of Rows * Number of Columns * 0.00025 Seconds

    You can find information on same in below document

    OBIEE 11g|12c: Export Guidance And Recommendations For Working With Microsoft Office (Doc ID 1558070.1)

    For performance related parameters you can refer to below mentioned OBIEE KM document, it says OBIEE 11g but it same for OBIEE 12c only difference is configuration file location

    OBIEE 11g: How To Improve the Functionality of Exporting Data from Analyses, Dashboards, and other Oracle BI Presentation Catalog Objects into Microsoft Excel with OBIEE 11.1.1.7.131017 and Later (Doc ID 1595671.1)

  • User_TML1V
    User_TML1V Rank 2 - Community Beginner
    • Export
      to excel 2007+ makes use of BIP Libraries for export as it export report along
      with formatting present within the report henc it generally takes up more time
      to export than export to CSV where only data gets exported hence its faster.

    1. What is your exact OBIEE 12c Version
      is it 12.2.1.0.X , 12.2.1.1.X or 12.2.1.2.X, where X is bundle patch if applied
      in the environment?
    2. 12.2.1.2.0

    b)
    Is your export to excel 2007+ failing or its just taking to much time to
    export?

    Both, sort of.  The first try of export in the morning goes well because the server is restarted then.
    And the second time of the day I try to export to excel It crashes. The javahost has assigned memory for the clients. When you
    fill-up the memory, there is no junk handler that deletes that part of the
    memory that are not being used. So I try to fix that. But the export itself is
    taking a long time.

    1. Export to excel 2007+ depend on many
      factors and hence could be slower, for starters what are the Number of Rows and
      Columns ou are trying to export to Excel 2007+?

    The numbers are about 10 000 – 400 000 rows

    d)
    To calculate approximate time for report export to Excel 2007+ you can use
    below formula

    Number
    of Rows * Number of Columns * 0.00025 Seconds

    You
    can find information on same in below document

    Thanks

    OBIEE 11g|12c:
    Export Guidance And Recommendations For Working With Microsoft Office (    Doc ID 1558070.1)

    For
    performance related parameters you can refer to below mentioned OBIEE KM
    document, it says OBIEE 11g but it same for OBIEE 12c only difference is
    configuration file location

    OBIEE 11g: How To
    Improve the Functionality of Exporting Data from Analyses, Dashboards, and
    other Oracle BI Presentation Catalog Objects into Microsoft Excel with OBIEE
    11.1.1.7.131017 and Later (    Doc ID 1595671.1)

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Did you go through mentioned document

    OBIEE 11g: How To Improve the Functionality of Exporting Data from Analyses, Dashboards, and other Oracle BI Presentation Catalog Objects into Microsoft Excel with OBIEE 11.1.1.7.131017 and Later (Doc ID 1595671.1)

    You can also go through OBIEE 12c Infrastructure Tunning Guide as it has precise suggestion related to Java Host under section "4.3 Oracle® JavaHost Component"

    OBIEE 12c: Best Practices Guide for Infrastructure Tuning Oracle® Business Intelligence Enterprise Edition 12c (12.2.1) (Doc ID 2106183.1)

    Go through above documents it covers all the aspects of increasing export performance.

    Also check jh.log from following location <DOMAIN HOME>\servers\obijh1\logs when your export fails, to verify what is the error reported upon export failure, so that you can make configuration changes accordingly.