OBIEE11g - Export to Excel issue

Solution:

To solve this issue we have taken the help from Oracle support by creating an P1 Service Request. Even though its not a permanent solution its serving the requirements for now. Oracle said they are going to provide the permanent solution in the future version which is 11.1.1.7.0 ( Its going to be a bundle patch mostly). The solution is as follows...

1)      Go to the following path to edit controlmessages.xml file 

/<OBIEE_HOME>/Oracle_BI1/bifoundation/web/msgdb/messages

           Fix: do the following changes
          Change export "format=mht" to "format=excel"
Note: Replace the text  “mht” to “excel” . Don’t forget to take the back up for the controlmessages.xml file before editing. 
Don’t place the back up in the same folder, save the back up in a different folder.

2)      Go to the following path to edit config.xml file 

<OBIEE_HOME>/instances/instance1/config/OracleBIJavaHostComponent/coreapplication_obijh1

Fix: do the following changes

Before:

<XMLP>

      <InputStreamLimitInKB>8192</InputStreamLimitInKB>

      <ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing>

   </XMLP>

<DVT>

      <InputStreamLimitInKB>8192</InputStreamLimitInKB>

</DVT>

After:

<XMLP>

      <InputStreamLimitInKB>0</InputStreamLimitInKB>

      <ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing>

</XMLP>

<DVT>

      <InputStreamLimitInKB>0</InputStreamLimitInKB>

</DVT>

Note: 0 represents unlimited. No Need to restart the services.

Result: Exporting to excel in OBIEE report is creating huge file size. Before fix for 5000 records the file size was 1.6 MB and after fix the file size was 800KB