SATYA RANKI REDDY OBIEE SOLUTIONS

Reduce file size by downloading a request/analysis to native excel format directly instead of mhtml (OBIEE 11.1.1.6.0)

I faced problem while downloading a request/analysis to native excel in OBIEE 11.1.1.5 and I tried to find solution from Oracle support. Here I saw bug number with the same problem. Oracle Support BugID :12763784
Problem :
The file downloaded is in mhtml format which consumes a lot of space when the
same file is re saved as .xls or .xlsx the size of the file is much lesser.
Customer Requirement:
Customer required to reduce file size by downloading a request to native
excel format directly instead of mhtml.
They can’t open the downloaded excel files because the file size is too
huge(ex.300MB).
My customer is also looking for  true Excel (not in mhtml format).
For this problem/Questions we have solution in OBIEE 11.1.1.6 version.(Not less than OBIEE 11.1.1.5 version)
Steps:
Find the below steps for Excel Export config file modifications.
1. Navigate to the path “<MiddlewareHome>\Oracle_BI1\bifoundation\web\msgdb\messages” and edit the viewscontrolmessages.xml file .
2.Where ever you find Format=mht , change it to Format=excel (Find the attached .doc for reference)
Note : You can also add your own entry for customization so that we will get both existing and customized option while exporting analysis/report/request.
3.Login to OBIEE, go to Administration –> Reload Files and Metadata4.Yes, we will  be able to export with the reports with the .xlsx format with the less disk space .(no need to restart services)
Note : You can also keep the existing(Native export) and add the tag for customized export.

• Example to Compare Native export and Customized export :

Let’s take Order Details as Example

1. Order Details Report with Native OBIEE feature:

Export report to excel

Save File

Give name and save it.

Result is

2.Order Details Report with after customization:

Export it to Excel

Save File

Give name and save it.

Result is

Thanks,
Satya Ranki Reddy