Free Sample
+ Collection

SAP BusinessObjects Dashboards 4.0 Cookbook

David Lai, Xavier Hacking

Over 90 simple and incredibly effective recipes for transforming your business data into exciting dashboards with SAP BusinessObjects Dashboards 4.0 Xcelsius with this book and eBook
RRP $32.99
RRP $54.99
Print + eBook

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849681780
Paperback352 pages

About This Book

  • Learn valuable Dashboard Design best practices and tips through easy to follow recipes
  • Become skilled in using and configuring all Dashboard Design components
  • Learn how to apply Dynamic Visibility to enhance your dashboards
  • Get introduced to the most important add-ons available for Dashboard Design with the most up to date information for Dashboards 4.0


Who This Book Is For

If you are a developer with a good command and knowledge of creating dashboards, but are not yet an advanced Dashboard Design user, then this is the perfect book for you. You should have a good working knowledge of Microsoft Excel as well as knowledge of basic dashboard practices, though experience of Dashboard Design as a specific dashboard tool is not essential.

Table of Contents

Chapter 1: Staying in Control
Making the spreadsheet more readable with colors
Making the spreadsheet more readable with comments
Making the spreadsheet more readable using borders
Using named ranges
Selecting all worksheet cells with one click
Copying the formatting of one cell to another cell or range
Debugging your spreadsheets
Navigation between worksheets
Grouping the canvas components
Chapter 2: Data Visualization
Adding a line chart to your dashboard
Using the bullet chart
Using sparklines
Using the combination chart
Using the pie chart
Using the XY chart
Using the bubble chart
Using the radar chart
Using the OHLC chart and candlestick chart
Sorting series
Zooming in on charts
Scaling the y-axis
Using the tree map
Showing a trend without a chart
Displaying raw data
Illustrating single values
Chapter 3: From a Static to an Interactive Dashboard
Drilling down from a chart
Selecting your data from a list
Using the Filter Selector component for hierarchies
Alternative hierarchy selection method
Using Filtered Rows
Using maps to select data of an area or country
Adding a MacOSX loading dock to your dashboard
Resetting your data (reset button)
Making selections from a custom image (push button and image component)
Inputting data values
Using Play Selector/Play Control
Opening up a Web Intelligence report using dashboard parameters
Selecting calendar dates
Using sliders to create a what-if scenario
Chapter 4: Dynamic Visibility
Switching between different charts
Building a pop-up screen
Creating a mouse-over help text pop-up
Password protecting your dashboard
Chapter 5: Using Alerts
Adding alerts to a column chart
Using alerts in a gauge
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
Chapter 6: Advanced Components
Printing your dashboard
Grouping and organizing components with the canvas container
Using dashboard scenarios
Using the grid component
Creating a slide show
Using the panel set component
Using the history component
Data insertion with the Source data component
Analyzing trends
Chapter 7: Dashboard Look and Feel
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
Using the panel container
Using the tab set container
Making tables look pretty
Smart use of quadrants
Chapter 8: Dashboard Connectivity
Creating a news ticker with Excel XML Maps
Using Query as a WebService (QaaWS)
Using Live Office connection
Connecting to SAP BW
Using Universe queries
Passing values from dashboard to dashboard with Flash Variables
Accessing dashboards with live data outside of Infoview using CELogonToken
Chapter 9: Exporting and Publishing
Exporting to a standard SWF, PPT, PDF, and so on
Exporting to SAP Business Objects Enterprise
Publishing to SAP BW
Housing your dashboard in Dashboard Builder
Creating Adobe Air Applets from Dashboard Design dashboard
Chapter 10: Top Third-Party Add-ons
Managing add-ons in Dashboard Design
Connecting to CSV-files with the CSV-connector
Integrating Google Maps with the GMaps plugin
Connecting to with DashConn
Transferring data between dashboards with Data Sharer
Presenting micro charts in a tree grid
Integrating Web Intelligence with Antivia XWIS

What You Will Learn

  • Become fully equipped with best practices for using the Dashboard Design spreadsheet
  • Present data using the wide variety of data visualization components
  • Learn how to make dashboard components interactive for an enhanced user experience
  • Take advantage of Dynamic Visibility features on the dashboard
  • Master manipulating the look and feel of your dashboards
  • Gain confidence in using alerts on charts and other components
  • Get to grips with advanced Dashboard Design components like the Trend Analyzer, Fisheye Picture Menu, History Component, and the Canvas Component
  • Optimize the user experience of the dashboard
  • Connect your dashboard to live data sources
  • Export and publish the Dashboard Design model into several environments.
  • Learn about the most applicable add-ons available for your dashboard requirements.
  • Master setting up alerts on charts, gauges, maps and scorecards

In Detail

Xcelsius 2008 was recently included in SAP’s BusinessObjects 4.0 family, rebranding “Xcelsius Enterprise” as “SAP BusinessObjects Dashboards 4.0”. With features like flexible design and what-if scenarios, the powerful dashboarding software allows enterprises to make business decisions at a glance, and this book allows you to go far beyond the basics of these techniques.

This cookbook full of practical and applicable recipes will enable you to use the full latest capabilities of Dashboard Design to visually transform your business data. A wide range of recipes will equip you with the knowledge and confidence to perform tasks like configuring charts, creating drill- downs, making component colors dynamic, using alerts in maps, building pop-up screens, setting up What-If scenarios, and many more.

The recipes begin by covering best practices for using the Dashboard Design spreadsheet, the data-model, and the connection with the components on the canvas, later moving on to some from-the-trenches tricks for using Excel within Dashboard Design. The book then guides you through the exploration of various data visualization components and dashboard interactivity, as well as offering recipes on using alerts, dashboard connectivity, and making the most of the aesthetics of the dashboard. Finally, the recipes conclude by considering the most important add-ons available for Dashboard Design and enabling you to perform relevant and useful tasks straight away.


Read More