Combine SAP NetWeaver BW, Xcelsius, and Crystal Reports for Personalized Reporting

  • by Ingo Hilgefort, Vice President of Product Management, Visual BI Solutions
  • August 19, 2009
Find out how you can combine Xcelsius 2008 and Crystal Reports 2008 with your SAP NetWeaver BW system to show aggregated data in your dashboard and then navigate to the detailed data in Crystal Reports. By combining these two applications, you can show highly summarized data to your executives and managers, while allowing analysts to drill down to a Crystal Reports object to view more details about the data.
Key Concept

Xcelsius allows you to create stunning data visualizations and Crystal Reports allows you to create detailed-oriented, formatted reports. You can use both applications on top of your SAP data. By combining them, you can enable the navigation from aggregated data in your dashboard to detailed data in your formatted report.

You can combine Xcelsius visualization with a report created in Crystal Reports to take advantage of the summarized data in Xcelsius and the detailed reporting in Crystal Reports. I will show you how to enhance an Xcelsius dashboard so that the user can view aggregated data in the dashboard. The user can then navigate from the dashboard to a detailed Crystal Reports object, which retrieves the data from a DataStore object (DSO) layer.

In the first article in this update, I created an Xcelsius dashboard that shows the open orders value broken down by country. The user can select the time frame for the shown data. For the Crystal Reports object, you use the DSO layer and show the open order value by region and material. In addition, you can filter the data by country and a time range, whereby the selection values are transferred to the Crystal Reports object from the Xcelsius dashboard each time the user navigates to the detailed report.

For the Crystal Reports object, I’m using the SAP NetWeaver BW query shown in Figure 1.

Ingo Hilgefort

Ingo Hilgefort started his career in 1999 with Seagate Software/Crystal Decisions as a trainer and consultant. He moved to Walldorf for Crystal Decisions at the end of 2000, and worked with the SAP NetWeaver BW development team integrating Crystal Reports with SAP NetWeaver BW. He then relocated to Vancouver in 2004, and worked as a product manager/program manager (in engineering) on the integration of BusinessObjects products with SAP products. Ingo's focus is now on the integration of the SAP BusinessObjects BI suite with  SAP landscapes, such as SAP BW and SAP BW on SAP HANA, focusing on end-to-end integration scenarios. In addition to his experience as a product manager and in his engineering roles, Ingo has been involved in architecting and delivering deployments of SAP BusinessObjects software in combination with SAP software for a number of global customers, and has been recognized by the SAP Community as an SAP Mentor for SAP BusinessObjects- and SAP integration-related topics. Currently, Ingo is the Vice President of Product Management and Product Strategy at Visual BI Solutions, working on extensions to SAP’s product offering such as SAP BusinessObjects Design Studio and SAP Lumira. You may follow him on Twitter at @ihilgefort.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.