Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
SAP BusinessObjects Dashboards 4.1 Cookbook
Mar, 2015 | 452 pages
No titles found
Table of Contents (26 chapters)
SAP BusinessObjects Dashboards 4.1 Cookbook
SAP BusinessObjects Dashboards 4.1 Cookbook
Credits
Credits
Foreword
Foreword
About the Author
About the Author
Acknowledgments
Acknowledgments
About the Author
About the Author
Acknowledgments
Acknowledgments
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Staying in Control
Staying in Control
Introduction
Using the Object Browser
Searching for components
Grouping the canvas components
Making the spreadsheet more readable with colors
Making the spreadsheet more readable with comments
Making the spreadsheet more readable with borders
Using named ranges
Copying the format of one cell to another cell or range
Debugging the spreadsheets
Navigating between worksheets
2
Data Visualization
Data Visualization
Introduction
Adding a line chart to your dashboard
Using a bullet chart
Using sparklines
Using a combination chart
Using a waterfall chart
Using a pie chart
Using a scatter plot chart
Using a bubble plot chart
Using a radar chart
Using an OHLC chart and a candlestick chart
Sorting series
Zooming in on charts
Scaling the y-axis
Using a tree map
Showing a trend without a chart
Displaying raw data
Illustrating single values
3
From a Static to an Interactive Dashboard
From a Static to an Interactive Dashboard
Introduction
Selecting your data from a list
Drilling down from a chart
Using the Filter selector component for hierarchies
An alternative hierarchy selection method
Using the Hierarchical Table
Using Filtered Rows
Using maps to select data of an area or country
Adding a Mac OS X-looking dock to your dashboard
Resetting your data (the reset button)
Making selections from a custom image (the push button and image component)
Inputting data values
Using the Play Selector / Play Control component
Opening up a Web Intelligence report using dashboard parameters
Selecting calendar dates
Using sliders to create a what-if scenario
4
Dynamic Visibility
Dynamic Visibility
Introduction
Switching between different charts
Building a pop-up screen
Creating a mouseover help text popup
Password protecting your dashboard
5
Using Alerts
Using Alerts
Introduction
Adding alerts to a column chart
Making alert ranges dynamic
Displaying alerts on a map
Displaying alerts of different thresholds on a map
Using bindable colors to control alert coloring from a central location
Using alerts in a Scorecard
6
Advanced Components
Advanced Components
Introduction
Printing your dashboard
Grouping and organizing components with the Canvas Container
Using dashboard scenarios
Using the Grid component
Creating a slideshow
Using the Panel Set component
Using the History component
Inserting data with the Source Data component
Analyzing trends
7
Dashboard Look and Feel
Dashboard Look and Feel
Introduction
Changing the look of a chart
Adding a background to your dashboard
Using color schemes
Sharing a color scheme
Working with themes
Making component colors dynamic
Dynamic XY positioning and sizing of components
Using the Panel Container
Using the Tab Set container
Making tables look pretty
Using quadrants smartly
Creating/using a dashboard template
8
Dashboard Data Connectivity
Dashboard Data Connectivity
Introduction
Creating a news ticker with Excel XML Maps
Using Query as a Web Service (QaaWS)
Using Live Office Connection
Using BI Web Services to consume a Webi report
Using the SAP NetWeaver BW Connection
Using the Query Browser
Passing values from dashboard to dashboard with Flash Variables
9
Exporting and Publishing
Exporting and Publishing
Introduction
Exporting to SWF, PPT, PDF, and other file types
Publishing to SAP BusinessObjects BI Platform
Housing your dashboard in a BI Workspace
Publishing to SAP BW
Going mobile
10
Top Third-party Add-ons
Top Third-party Add-ons
Introduction
Managing add-ons in SAP BusinessObjects Dashboards
Connecting to CSV files with the CSV Connector
Integrating Google Maps with the CMaps plugin
Connecting to Salesforce.com with DashConn
Presenting micro charts in a Tree Grid
Integrating Web Intelligence with Antivia XWIS Advantage Express
Advanced printing with Xcelsius Dashboard Printer
SUCCESS with graphomate charts
11
Performance Tuning
Performance Tuning
Introduction
Improving Excel spreadsheet performance
Using scheduled Webis to save on querying time
Running connections after loading the dashboard
Checking master data loading performance of connections
Optimizing BEx Query performance
Using Fiddler to identify the cause of performance issues
12
Increasing Productivity
Increasing Productivity
Introduction
Using the Spreadsheet Table component to debug
Time-saving tips during dashboard development
Fixing corrupt XLF files
Real-world Dashboard Case Studies
Real-world Dashboard Case Studies
What-if scenario – Mortgage Calculator
Sales/Profit dashboard example
Additional Resources – Supported Excel Functions and System/Software Requirements
Additional Resources – Supported Excel Functions and System/Software Requirements
Online resources
Supported Excel functions
System and software requirements
The Future of Dashboarding with SAP Design Studio
The Future of Dashboarding with SAP Design Studio
What is SAP BusinessObjects Design Studio?
SAP BusinessObjects Dashboards versus SAP BusinessObjects Design Studio
What is the SAP roadmap for dashboarding?
Index
Index

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. The user will then be able to click on a news article and the website will automatically pop up. To set up this connection to an online news website, we will use the Excel XML Maps connection.

Getting ready

Make sure the spreadsheet has a DEVELOPER tab, and that you are connected to the Internet.

If you do not see the DEVELOPER tab, please follow these instructions:

  1. Click on FILE.

  2. Click on Options.

  3. Click on Customize Ribbon.

  4. Check the DEVELOPER box.

How to do it...

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

  2. Copy the URL of the Top Stories RSS feed: http://rss.cnn.com/rss/edition.rss.

    Note

    RSS is an XML-based method by which web content can be easily and quickly distributed when it is changed or newly entered into a website.

  3. Open a new SAP BusinessObjects Dashboards file...

Previous Section
End of Section 3
Next Section