Why is it going slowly?

Question

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?

Syedsalmancs110 · Answer

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.

User_TML1V · Answer

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

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

* 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 · Answer

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)