SAP NetWeaver BW and Xcelsius: Develop Eye-Catching Reports with Real-Time Updates

  • by Oliver Willoughby, Technical Specialist of Delivery Operations, SAP America, Inc.
  • Derek Johnson, Program Manager
  • July 23, 2009
Discover how to develop a Web service with Microsoft .NET that you can use to create Xcelsius applications that access SAP NetWeaver BW data dynamically. This allows you to develop applications that are always relevant and current. Downloadable sample data to try out this process is included.
Key Concept

Xcelsius provides a set of design tools to create effective dashboards. The drag-and-drop design environment and the data connectivity make these applications fun and allow designers to import a wide range of information into their analytics. Using the XML data connection in Xcelsius, you can leverage your existing data and systems to provide dynamic dashboards.

Integrating your SAP NetWeaver BW data into an Xcelsius application is an easy way to leverage your existing data warehousing investment and provide a great looking user interface to help drive business decisions. Taking advantage of SAP NetWeaver BW’s delivered remote-enabled function modules, you can create a simple .NET Web service to interface SAP NetWeaver BW and Xcelsius. This enables a dynamic connection between the two applications so that data can be updated in real time.

We will show you how to set up the .NET Web service that reads SAP NetWeaver BW query data. This example provides a basis for creating more complex analytical applications. Although this example is geared towards reading SAP NetWeaver BW query data, you could also apply the process to reading non-SAP data and structure the data in a way that is conducive to Xcelsius reporting.

The prerequisites for our solution are:

  • SAP NetWeaver BW 7.0
  • Xcelsius 2008

In addition, the .NET Web service prerequisites are:

  • Windows Server 2000 or later
  • Internet Information Services (IIS) 5.0 or higher
  • Versions 1.1 and 2.0 of the Microsoft .NET Framework installed on the server
  • IIS configured to run ASP.NET 2.0 applications

Oliver Willoughby

Oliver Willoughby is a technical consultant on the Delivery Operations & Technology team at SAP America. He is currently responsible for the design, development, and maintenance of internal applications that support SAP’s consulting organization. Oliver has more than 12 years experience developing solutions with Microsoft technologies.

See more by this author

Derek Johnson

Derek Johnson is a program manager on the Delivery Operations Team with SAP America, Inc. He is responsible for the design and development of analytical and reporting applications to support SAP America’s consulting organization. Formerly a platinum consultant with the National Competency Center (NCC), he has more than 10 years experience working with SAP NetWeaver BW. Besides traditional data modeling and reporting, he also has extensive experience with Yahoo! Widgets, SAP NetWeaver Visual Composer, Web reporting, BW data mining, Xcelsius, ABAP, and JavaScript. He holds a BS degree in engineering from the University of Michigan-Ann Arbor, an MS degree in engineering from Wayne State University-Detroit, and an MS degree in management information systems from Case Western Reserve University-Cleveland.

See more by this author


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.