You are previewing SAP BusinessObjects Dashboards 4.0 Cookbook.
O'Reilly logo
SAP BusinessObjects Dashboards 4.0 Cookbook

Book Description

Over 90 simple and incredibly effective recipes for transforming your business data into exciting dashboards with SAP BusinessObjects Dashboards 4.0 Xcelsius

  • 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

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)

Table of Contents

  1. SAP BusinessObjects Dashboards 4.0 Cookbook
    1. SAP BusinessObjects Dashboards 4.0 Cookbook
    2. Credits
    3. Foreword
    4. About the Authors
    5. Acknowledgement
    6. Acknowledgement
    7. About the Reviewers
    8. www.PacktPub.com
      1. Support files, eBooks, discount offers and more
        1. Why subscribe?
        2. Free access for Packt account holders
        3. Instant updates on new Packt books
    9. Preface
      1. What is SAP Business Objects Dashboards (formerly Xcelsius)?
      2. What this book covers
      3. What you need for this book
      4. Who this book is for
      5. Conventions
      6. Reader feedback
      7. Customer support
        1. Errata
        2. Piracy
        3. Questions
    10. 1. Staying in Control
      1. Introduction
      2. Making the spreadsheet more readable with colors
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
      3. Making the spreadsheet more readable with comments
        1. Getting ready
        2. How to do it...
        3. How it works...
      4. Making the spreadsheet more readable using borders
        1. Getting ready
        2. How to do it...
        3. There's more...
          1. Toolbar border button
          2. Use multiple worksheets
          3. Place your logic wisely
      5. Using named ranges
        1. How to do it...
        2. How it works...
        3. There is more...
          1. Defined named ranges
          2. Name Manager
      6. Selecting all worksheet cells with one click
        1. How to do it...
        2. How it works...
        3. There's more...
      7. Copying the formatting of one cell to another cell or range
        1. How to do it...
        2. How it works...
        3. There's more...
      8. Debugging your spreadsheets
        1. How to do it...
        2. How it works...
        3. There's more...
      9. Navigation between worksheets
        1. How to do it...
        2. How it works...
      10. Grouping the canvas components
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Hiding components
          2. Locking components
    11. 2. Data Visualization
      1. Introduction
      2. Adding a line chart to your dashboard
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Manually binding data
          2. Hide/show series
          3. Other charts: bar chart and column chart
          4. Other charts: area chart
          5. Other charts: stacked charts
      3. Using the bullet chart
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
      4. Using sparklines
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Header labels
          2. Show low and high values
      5. Using the combination chart
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
      6. Using the pie chart
        1. Getting ready
        2. How to do it...
        3. How it works...
      7. Using the XY chart
        1. Getting ready
        2. How to do it...
        3. How it works...
      8. Using the bubble chart
        1. Getting ready
        2. How to do it...
        3. How it works...
      9. Using the radar chart
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
      10. Using the OHLC chart and candlestick chart
        1. Getting ready
        2. How to do it...
        3. How it works...
      11. Sorting series
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
      12. Zooming in on charts
        1. Getting ready
        2. How to do it...
        3. How it works...
      13. Scaling the y-axis
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
          1. Variable maximum limits
          2. Allow Zoom Out Only
      14. Using the tree map
        1. Getting ready
        2. How to do it...
        3. How it works...
      15. Showing a trend without a chart
        1. Getting ready
        2. How to do it...
        3. How it works
      16. Displaying raw data
        1. Getting ready
        2. How to do it...
        3. How it works...
      17. Illustrating single values
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
          1. Scaling
    12. 3. From a Static to an Interactive Dashboard
      1. Introduction
      2. Drilling down from a chart
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
      3. Selecting your data from a list
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See also
      4. Using the Filter Selector component for hierarchies
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
      5. Alternative hierarchy selection method
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      6. Using Filtered Rows
        1. How to do it...
        2. How it works...
      7. Using maps to select data of an area or country
        1. How to do it...
        2. How it works...
        3. There's more...
      8. Adding a MacOSX loading dock to your dashboard
        1. How to do it...
        2. How it works...
        3. There's more...
      9. Resetting your data (reset button)
        1. How to do it...
        2. How it works...
      10. Making selections from a custom image (push button and image component)
        1. How to do it...
        2. How it works...
        3. See Also
      11. Inputting data values
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      12. Using Play Selector/Play Control
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      13. Opening up a Web Intelligence report using dashboard parameters
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See also
      14. Selecting calendar dates
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      15. Using sliders to create a what-if scenario
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
    13. 4. Dynamic Visibility
      1. Introduction
      2. Switching between different charts
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
          1. Other components
          2. Status values
      3. Building a pop-up screen
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
      4. Creating a mouse-over help text pop-up
        1. Getting ready
        2. How to do it...
        3. How it works
      5. Password protecting your dashboard
        1. Getting ready
        2. How to do it...
        3. How it works...
    14. 5. Using Alerts
      1. Introduction
      2. Adding alerts to a column chart
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
        5. There's more...
      3. Using alerts in a gauge
        1. Getting ready
        2. How to do it...
        3. How it works...
      4. Making alert ranges dynamic
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See Also
      5. Displaying alerts on a map
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See also
      6. Displaying alerts of different thresholds on a map
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      7. Using bindable colors to control alert coloring from a central location
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      8. Using alerts in a scorecard
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
    15. 6. Advanced Components
      1. Introduction
      2. Printing your dashboard
        1. Getting ready
        2. How to do it...
        3. How it works...
      3. Grouping and organizing components with the canvas container
        1. Getting ready
        2. How to do it...
        3. How it works...
      4. Using dashboard scenarios
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
      5. Using the grid component
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
      6. Creating a slide show
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
      7. Using the panel set component
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
          1. Linking to files instead of embedding
          2. Panel behavior
      8. Using the history component
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
      9. Data insertion with the Source data component
        1. Getting ready
        2. How to do it...
        3. How it works...
      10. Analyzing trends
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
    16. 7. Dashboard Look and Feel
      1. Introduction
      2. Changing the look of a chart
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      3. Adding a background to your dashboard
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
      4. Using color schemes
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
      5. Sharing a color scheme
        1. Getting ready
        2. How to do it...
        3. How it works...
      6. Working with themes
        1. How to do it...
        2. How it works...
      7. Making component colors dynamic
        1. How to do it...
        2. How it works...
        3. There's more...
      8. Using the panel container
        1. How to do it...
        2. How it works...
        3. There's more...
      9. Using the tab set container
        1. How to do it...
        2. How it works...
        3. There's more...
      10. Making tables look pretty
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See Also
      11. Smart use of quadrants
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See Also
    17. 8. Dashboard Connectivity
      1. Introduction
      2. Creating a news ticker with Excel XML Maps
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
          1. Adding the Developer tab
          2. Usage tab
          3. Connection Refresh button
      3. Using Query as a WebService (QaaWS)
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
          1. Using prompts
          2. Methods
      4. Using Live Office connection
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
          1. Using prompts
      5. Connecting to SAP BW
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
          1. Using variables and filters
          2. Other Output Values
          3. Returned data format
      6. Using Universe queries
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
          1. Query Prompt Selector
          2. Query Refresh button
      7. Passing values from dashboard to dashboard with Flash Variables
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
          1. Using multiple variables
          2. Passing multiple values
      8. Accessing dashboards with live data outside of Infoview using CELogonToken
        1. Getting ready
        2. How to do it...
          1. How it works...
            1. How does Dashboard Design consume CELogonToken?
            2. CELogonToken at runtime
            3. Step-by-step code explanation
    18. 9. Exporting and Publishing
      1. Introduction
      2. Exporting to a standard SWF, PPT, PDF, and so on
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
      3. Exporting to SAP Business Objects Enterprise
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See Also
      4. Publishing to SAP BW
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
      5. Housing your dashboard in Dashboard Builder
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
      6. Creating Adobe Air Applets from Dashboard Design dashboard
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
    19. 10. Top Third-Party Add-ons
      1. Introduction
      2. Managing add-ons in Dashboard Design
        1. Getting ready
        2. How to do it...
      3. Connecting to CSV-files with the CSV-connector
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
          1. Calculations
          2. Exporting data to a CSV file
      4. Integrating Google Maps with the GMaps plugin
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
          1. More features
          2. XGlobe and XYahooMap
      5. Connecting to Salesforce.com with DashConn
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
          1. Salesforce.com Data Manager Connection
          2. Working Mode settings
      6. Transferring data between dashboards with Data Sharer
        1. Getting ready
        2. How to do it...
        3. How it works...
      7. Presenting micro charts in a tree grid
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
          1. Data grid
          2. More information
      8. Integrating Web Intelligence with Antivia XWIS
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There is more...
          1. Antivia Slice and Dice component
          2. Antivia Export component
          3. Alerts
          4. Antivia Timer component
          5. Taking the dashboard offline
    20. A. Real World Dashboard Case Studies
      1. What-if scenario: mortgage calculator
        1. Getting ready
        2. How to do it...
        3. How it works...
      2. Sales/profit dashboard example
        1. Getting ready
        2. How to do it...
        3. How it works...
    21. B. Additional Resources— Supported Excel Functions and System/Software Requirements
      1. Online resources
      2. Supported Excel functions
      3. System and software requirements