Were hiring

Clariba Job Opportunities

Clariba as a BI leader consulting company strives to constantly improve and adapt to the changing market. This is why we recruit talented individuals, identify potential and grow this further.

Read more about our career opportunities and submit your CV.

Clariba Blog

Welcome to the Clariba business intelligence blog. We invite you to read our posts related to SAP BusinessObjects, Data Management and other BI topics, written by our consultants. If you have questions or comments, please let us know.

«

»

Export2Excel v3 for Xcelsius 2008 SP3 (Tomcat version)

March 9th, 2010 / Luca Spinelli

About eight months ago we posted an Xcelsius solution called Export2Excel on the myxclesius.com blog. Thanks to support and comments from the Xcelsius developer community and some serious investigating, it is a pleasure for me to announce that the new Export2Excelv3 for Xcelsius (Tomcat version) is now up and running. Version 3 works with Xcelsius 2008 SP3 and it supports multiple languages. You will find the Export2Excelv3 files at the end of this post.*

For those who are new to Export2Excel, this component allows BI Developers to add export functionality to an Xcelsius dashboard so that end users can then filter results by selecting part of their dashboard. It is a great option for users who want to look at data outside of the predefined dashboard components.

Xcelsius 2008 SP3

When SAP Business Objects released Xcelsius 2008 SP3, we noticed that there was a change in the exported xml string. Xcelsius is now exporting the xml on different lines instead of a single line. Thanks to the help of other contributors we reached a solution that involves reading and converting all the lines. As a result, our new Export2Excelv3 only works with Xcelsius 2008 SP3. If you still have the SP2, please contact us for the v2 file (also with multi-language support).

Export to Multiple Languages

The new Export2Excelv3 can export multiple languages (e.g. Arabic, Japanese, Chinese and languages with special accents such as ö ü ÿ ä ý). We decided to add this to the new version as some of the users were asking about this functionality. In addition we are doing a lot of work in the Middle East so it is interesting for Clariba to have the Arabic characters in case any of our customers are interested.

How to Configure Export2Excelv3

Follow the steps below to configure the Export2Excelv3 solution in your Xcelsius dashboard:

  1. Download the WAR file (Find the link at the end of this post)
  2. Copy the ExportToExcelv3.war into your Tomcat webapps folder
  3. Open the Data Manager
  4. Add XML connection
  5. Set the XML Data URL as http://<servername>:<port>/ExportToExcelv3/index.jsp
  6. Check the “Enable Send” function. This will contain the range of cells that you choose to export.
  7. Check the “Enable Load” function. Be sure that the Name is URLDummy (as highlighted in red in the screenshot below), and that the Range contains just one cell. This cell is the URL of the exported Excel file.

Note: Add a refresh connection and URL button on the Xcelsius dashboard to open this link.

Clariba Sample Dashboard

At Clariba, we have merged the functionalities of a refresh connection button and a URL button. As a result of this customized functionality, users can open an Excel file and begin their own analysis and comparisons if desired.

You will see the archive rar file for the code below. Just save and rename it to ExportToExcelv3.war and deploy it to your tomcat! If you have any questions or comments about the new version, just let me know.

Download: ExportToExcelv3.rar

* Copyright (C) 2011 Clariba. This free solution can be used, published or redistributed with appropriate credit to Clariba.

This entry was posted on Tuesday, March 9th, 2010 at 5:45 am and is filed under SAP Business Objects, Xcelsius. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

11 Responses to “Export2Excel v3 for Xcelsius 2008 SP3 (Tomcat version)”

  1. Massimo says:
    March 30, 2010 at 3:57 am

    We have used this solution for the creation of a dashboard with Excel data export. Thanks to the support of Luca Spinelli we have finally reach the goal.

    Very special Thanks to Luca and ClearPeaks!
    Massimo

  2. Phil says:
    April 17, 2010 at 2:15 am

    Hi Massimo,
    Did you implement on BOBJ 3.1 or XI R2?

    Thanks,
    Phil

  3. Luca Spinelli says:
    April 26, 2010 at 4:01 am

    Hi Phil,
    nice to see your comment. The feature works on both the versions. I have dashboards published on both the BO versions and they are working fine. Are you having issues with Export2Excelv3??

    Thanks and Best Regards,
    Luca

  4. Samer says:
    January 2, 2011 at 5:23 pm

    Many thanks Luka, you’re the best

  5. Mike says:
    February 26, 2011 at 2:06 am

    Thank you very much for this solution and it works great.
    I do have one error that I have tried to find a solution for but have failed.

    If I try to map more than 147 rows of data in the enable send section of the XML connection i get the Error #2032.
    As long as i select 147 or less everything runs fine. Is this just a limitation or is there a way around the error with more rows?

    Thank you!!
    Mike

  6. Martin says:
    May 23, 2011 at 3:56 pm

    Hi from Argentina,
    All the numbers in the output excel file are stored as Text, how can i fix it?
    Thanks.
    Martin

  7. Budi says:
    May 29, 2011 at 4:32 am

    Hi Luca,

    Thank you for your solution so I can download data from dashboard to Excel. :)

    But there is several issues regarding the naming of the excel file and numbering format.

    When I tried to click URL button at the same time with my friend, the files are exchange.
    What I see in my screen is my friend excel file and so on for my friend.

    How to fix this Luca? Í need to fix this immediately

    And about numbering format.
    the excel file generated using the text formated and also for number.
    can I set the number using the numeric format?
    could you tell me how to do that?

    I also happen the same error with mike.
    how to solve it?

    Thank you

    Regards,
    Budi

  8. Luca Spinelli says:
    June 6, 2011 at 9:20 am

    Hi all, sorry for being so late with my answers! I will be quicker from now on!

    @Mike: please check if you have any special char that XML does not like i.e “&”. there is no row limitation in this solution ;-) !

    @Martin: you can modify the JSP code and add the settings to the exported excel but the performance of the export will be slower. We implemented it during a V1 that we had to modify due to the performance.

    Let me know if any comments.
    Best Regards,
    Luca

  9. Debbie Bennett says:
    July 19, 2011 at 1:50 pm

    Could I possibly have a copy of the SP2 version please as I’m still waiting for our guys to patch to date.

    Thanks very much

    debbie

  10. Debasish says:
    August 4, 2011 at 10:26 am

    Hi Luca,

    I really appreciate your help. Your solution is awesome. Thanks again.

    Regards,
    Debasish

  11. Debasish says:
    August 16, 2011 at 10:34 am

    Hi Luca

    I have one quick question for you. Does your solution work if Xcelsius is using Websphere 6.1 server?

    Thanks,
    Debasish

Leave a Reply