Find out how you can use Xcelsius, SAP BusinessObjects Live Office, SAP NetWeaver BW, and Crystal Reports to provide compelling data visualizations and dashboards. For example, you can add simple drop-down selection boxes to your charts to allow users to easily manipulate the data views in real time.
With the current BI roadmap, Xcelsius is becoming the flagship product for simple dashboarding and data visualization. Crystal Reports, SAP BusinessObjects Web Intelligence, and universes can be data sources for your analytics. For complex composite applications, SAP recommends SAP NetWeaver Composition Environment and SAP NetWeaver Visual Composer in combination with Xcelsius.
Say you need to build a dashboard that shows the revenue for a variable period of time broken down by month in a dashboard. In addition, you want the functionality to allow users to select a country and specify start and end months to allow them to view a more detailed report created with Crystal Reports — for example, to view open orders by country for a given period of time. The dashboard retrieves the data from an SAP NetWeaver BW system via SAP BusinessObjects Live Office and via Query as a Web Service (QaaWS).
I’ll show you how you can set up this dashboard using Xcelsius, Crystal Reports, SAP BusinessObjects Live Office, and SAP NetWeaver BW. I’ll explain the three SAP NetWeaver BW queries you need to set up and demonstrate what you need to do to set up the Crystal Reports report. I’ll then show you what you need to do to set up connections between SAP NetWeaver BW and SAP BusinessObjects Live Office and Xcelsius and SAP Business Objects Live Office. (For information about the data connections involved, see the sidebar “Data Connectivity in SAP BusinessObjects XI 3.x.”)