Export to Excel using Apache Tomcat Server
Introduce users to the new export to Excel solution for SAP Xcelsius Dashboard using the Apache Tomcat (with file jsp) server.
The solution will allow end users to filter results by selecting part of a dashboard using the XML connection of Xcelsius dashboard.
Step for configuration is as follows:-
Note:- For SAP Xcelsius Dashboard SP3
1. Click here to download the rar/zip file.
2. Extract the rar/zip file and copy ExportToExcelv3 into the <Installed Directory>/Tomcat/webapps folder.
3. Restart the Tomcat Application Server
4. Open Xcelcius
5. Open the Data Manager and add XML Data Connection
6. Set the XML Data-URL to http://servername:Port/ExportToExcelv3/index.jsp
7. Tick "Enable Send" function, which contain the DataSet to be Export to Excel . Provide the range which you want to Export To Excel in Range Box.
Note: Please give the save naming convention as per the screen short i.e DataOutput.
8. Tick "Enable Load" function, which will generate URL for Export for Excel file. Type "URLDummy" as the name and provide the range contains just one cell. This cell is the URL of the exported Excel file.
Note: Please give the save naming convention as per the screen short i.e URLDummy.
9. Now take the component Connection Refresh Button and Select the XML Data Connection and form Behavior tab Tick the Refresh After Component are Loaded.
10. Last but not least add a URL Button, Select the URL cell which you have given for URLDummy.
