Creating a news ticker with Excel XML Maps

In this recipe, we will show you how to integrate a real-time news ticker into your dashboard. To set up this connection to an online news website, we will use the Excel XML Maps connection.

Getting ready

Make sure the spreadsheet area has a Developer tab, if you are using MS Excel 2007. If you do not see this tab, skip to the There is more... section of this recipe to set this up. Furthermore, you need a connection to the Internet.

Getting ready

How to do it...

  1. Go to http://www.cnn.com/. At the bottom of this site, you will see an RSS link. You can also go directly to http://www.cnn.com/services/rss/.
  2. Copy the URL of ...

Get SAP BusinessObjects Dashboards 4.0 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.