SAP BusinessObjects Dashboards 4.0 Cookbook

SAP BusinessObjects Dashboards 4.0 Cookbook
eBook: $32.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $87.98    Print cover: $54.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • 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


Book Details

Language : English
Paperback : 352 pages [ 235mm x 191mm ]
Release Date : May 2011
ISBN : 1849681783
ISBN 13 : 9781849681780
Author(s) : David Lai, Xavier Hacking
Topics and Technologies : All Books, Enterprise Products and Platforms, Cookbooks, Enterprise, SAP

Table of Contents

Chapter 1: Staying in Control
Chapter 2: Data Visualization
Chapter 3: From a Static to an Interactive Dashboard
Chapter 4: Dynamic Visibility
Chapter 5: Using Alerts
Chapter 6: Advanced Components
Chapter 7: Dashboard Look and Feel
Chapter 8: Dashboard Connectivity
Chapter 9: Exporting and Publishing
Chapter 10: Top Third-Party Add-ons
Appendix A: Real World Dashboard Case Studies
Appendix B: Additional Resources—Supported Excel Functions and System/Software Requirements
  • Chapter 1: Staying in Control
    • Introduction
    • 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
      • Introduction
      • 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
        • Introduction
        • 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
          • Introduction
          • 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
            • Introduction
            • 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
              • Introduction
              • 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
                • 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
                • Using the panel container
                • Using the tab set container
                • Making tables look pretty
                • Smart use of quadrants
                • Chapter 8: Dashboard Connectivity
                  • Introduction
                  • 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
                    • Introduction
                    • 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
                      • Introduction
                      • 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

                          David Lai

                          David Lai is an SAP Business Objects Consultant from Toronto, Canada. He has a degree in Computer Engineering from the University of Toronto. He currently specializes in SAP Business Objects and Data Warehousing work for clients which include SAP BusinessObjects Dashboards 4.0 (Xcelsius), Universe Design, and Web Intelligence. David has a passion for data visualization and best design practices with dashboards, which has led him to create his blog ( in 2008, as well as co-author and finally author “SAP BusinessObjects Dashboards 4.0 Cookbook”. David also enjoys speaking at conferences about best dashboard practices and making sense out of data. In his spare time he loves to spend time on many physical activities such as working out at the gym, salsa dancing, rock climbing, basketball and volleyball.

                          Xavier Hacking

                          Xavier Hacking is a SAP BI consultant from Eindhoven, The Netherlands and has a master's degree in Industrial Engineering and Management Science from the Eindhoven University of Technology. He has worked with a range of products from the SAP Business Intelligence portfolio, including SAP BW and SAP BusinessObjects Dashboards 4.0 (Xcelsius). He enjoys working on BI solutions that enable people to do their work in a better and more productive way. You can follow Xavier on Twitter ( or visit his blog (
                          Sorry, we don't have any reviews for this title yet.

                          Code Downloads

                          Download the code and support files for this book.

                          Submit Errata

                          Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.


                          - 1 submitted: last submission 11 Jan 2013

                          Errata type: Others | Page number: 274

                          In the 'Getting ready' section it is stated that you need a account. This needs to be a 'Developer' account to be able to work with the DashConn add-on. You can sign up for a free developer account at

                          Sample chapters

                          You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                          Frequently bought together

                          SAP BusinessObjects Dashboards 4.0 Cookbook +    ADempiere 3.6 Cookbook =
                          50% Off
                          the second eBook
                          Price for both: $47.10

                          Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                          What you will learn from this book

                          • 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.

                          Create Dynamic Dashboards from Business Data using SAP BusinessObjects Dashboards 4.0 (fka Xcelsius)


                          This guide to SAP BusinessObjects Dashboards 4.0 (formerly Xcelsius )is a cookbook packed full of practical recipes written in a clear, concise manner with annotated examples to empower readers to quickly accomplish specific dashboard tasks.

                          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.

                          Code Download and Errata
                          Packt Anytime, Anywhere
                          Register Books
                          Print Upgrades
                          eBook Downloads
                          Video Support
                          Contact Us
                          Awards Voting Nominations Previous Winners
                          Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                          Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software