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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.