Unable to export reports into a CSV file or Excel file

Issue:

Unable to export User Console reports into a CSV file or Excel file.

The file is downloaded as default.html instead of a CSV report or Excel file report.

Root Cause:

This is an issue with the Pentaho java script in 8.3.0.6

This issue has been reported on 5.5.26 and 5.5.27.

Permanent fix:

This issue will be fixed in 5.5.28 patch.

Workaround: (Can be applied on 5.5.26 OR 5.5.27)

Please find the attached: BDNA_32431_ExportReport.zip

The workaround updates the Pentaho version to 8.3.0.5 which does not cause the issue.

You can apply the patch by following the steps below:

0. We strongly recommend to manually back up everything on the following path as a pre step：
%NORMALIZE_BI_HOME%\Solution\system\analyzer

NOTE : '%NORMALIZE_BI_HOME%' is the location where user console installed.

Steps:
1. Download 'BDNA_32431_ExportReport.zip' and copy it to the host where User Console is installed.
Example: c:\BDNA_32431_ExportReport.zip
2. Close all web browsers, run the following commands in command prompt with administrators rights.
Every command must run after the previous one succeeds:
cd %NORMALIZE_BI_HOME%\bin
Updater.exe /file=c:\BDNA_32431_ExportReport.zip
3. Once above is successful, Login to user console and try to export report.

NOTE : The workaround is only for CSV file and Excel file exports. The workaround does not fix the PDF export.