[Bugfix 6766794 - DISCOVERER VIEWER/PLUS EXPORT TO EXCEL CONSUMES EXCESSIVE MEMORY AND FAILS]
This preference controls the subtotal format macro generation while exporting the worsheet to MicrosoftExcel. When a workbook contains a lot of subtotals, it takes huge memory, CPU usage and time to generate the macros. Hence excel export is very slow. Disabling this macro generation by setting
the preference SubtotalFormatMacros = 0 will improve the excel export.
How to apply this preference
------------------------------
a) Add "SubtotalFormatMacros" preference to pref.txt under the [Application] preference type
[Application]
SubtotalFormatMacros = 0 # 1 - will allow user to have the subtotal formatting in excel export [Default]
# 0 - will disable the subtotal macro generation
b) Save the pref.txt
c) Apply the Preference by running the following command
In Unix: $ORACLE_HOME/discoverer/util/applypreferences.sh
In Windows: $ORACLE_HOME\discoverer\util\applypreferences.bat
This preference controls the subtotal format macro generation while exporting the worsheet to MicrosoftExcel. When a workbook contains a lot of subtotals, it takes huge memory, CPU usage and time to generate the macros. Hence excel export is very slow. Disabling this macro generation by setting
the preference SubtotalFormatMacros = 0 will improve the excel export.
How to apply this preference
------------------------------
a) Add "SubtotalFormatMacros" preference to pref.txt under the [Application] preference type
[Application]
SubtotalFormatMacros = 0 # 1 - will allow user to have the subtotal formatting in excel export [Default]
# 0 - will disable the subtotal macro generation
b) Save the pref.txt
c) Apply the Preference by running the following command
In Unix: $ORACLE_HOME/discoverer/util/applypreferences.sh
In Windows: $ORACLE_HOME\discoverer\util\applypreferences.bat
No comments:
Post a Comment