Data excel export at dashboard level

[Marc]

Dear Team,

I am using Helical Insight 3.1. Most of my users are using dashboards. I want to give an option to an end user so that they can export the data (in excel) form of individual reports at the dashboard level. Right now the excel export at dashboard level is taking a snapshot and exporting it. This is especially useful when I have implemented the cascading at dashboard level
Can you help me with the solution?

Thank You,

[helicalforum]

Hi Marc,

Below are the steps to deploy

Helical_Excel export.zip (8.6 MB)

1. Download the above zip file. Copy all 6 files from the folder “Libraries” into the backend Helical Insight server location of the following path. Some of the files you may need to overwrite :

…\hi\apache-tomcat-7\webapps\hi-ee\WEB-INF\lib

2. Copy the “excelFile.jsp” into the below path :

…\hi\apache-tomcat-7\webapps\hi-ee\WEB-INF\jsp

3. Create a new folder in the hi-repository with the name as “hwf”

Path of hi-repository generally is :…\hi\hi-repository

Copy “ExcelAdhoc.hwf” file into this newly created hwf folder at the backend.

4. Restart the tomcat server.

5. Now for whichever reports you would like to enable this excel data export while you are creating the report apply excel customization as shown in the below image.

To enable the Excel Button Customization option please follow the below 2 steps
Step 1. Please download the excelButton.zip (3.9 KB) and place the file in the mentioned below location
…\hi\hi-repository\System\Admin\CustomScripts\generic\js
Step 2. Please download this image (excelExport.png) and put the same(image name should be same) in the below location
…\hi\apache-tomcat-7\webapps\hi-ee\images\scriptIcons
You can see the result in the below image

6. Click on the customize then click on excel then finally click on the generate icon.

7. When the above script is applied an “Excel” button will appear on the report. This will enable you to export the data into Excel format for any kind of chart / table / crosstabular as well.

Here is the outcome result

NOTE: If you are using view to create the reports, and those views are having comments then this excel export functionality might not work. Make sure that you have removed any comment etc from the view.

Thank You
From Team Helical.

[helicalforum]

In continuation of the above provided solution, there was a small issue identified with the above solution wherein the excel export still showed all data and not filtered out data. Please refer to this link wherein that solution has also been further provided.

Excel export patch giving error

Hello Helical, I am using 4.1 GA , I am using custom excel export functionality with below reference link We are facing the issue at dashboard level , when we apply filters at dashbord level the excel file which is getting downloaded is not showing filtered data. It is showing full data Thanks, Sesa.