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

Book Description

Over 100 simple and incredibly effective recipes to help transform your static business data into exciting dashboards filled with dynamic charts and graphics

In Detail

The widely used SAP BusinessObjects Dashboards software lets you transform data from any source into interactive dashboards.

The recipes begin by covering best practices for using the SAP BusinessObjects Dashboards spreadsheet. The book then guides you through the exploration of various data visualization components and dashboard interactivity, as well as using alerts, dashboard connectivity, publishing the dashboard, and making the most of the aesthetics of the dashboard. Finally, the recipes conclude by considering the most important add-ons available for SAP BusinessObjects Dashboards, performance tuning, and tips on increasing development productivity.

What You Will Learn

  • Become fully equipped with best practices when using the SAP BusinessObjects Dashboards spreadsheet

  • Present data using a wide variety of data visualization components

  • Discover how to make dashboard components interactive for an enhanced user experience

  • Take advantage of Dynamic Visibility features

  • Connect your dashboard to live data sources

  • Export and publish the SAP BusinessObjects Dashboards model into several environments

  • Improve the performance of your dashboards and increase your productivity as a dashboard developer

  • Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.

    Table of Contents

    1. SAP BusinessObjects Dashboards 4.1 Cookbook
      1. Table of Contents
      2. SAP BusinessObjects Dashboards 4.1 Cookbook
      3. Credits
      4. Foreword
      5. About the Author
      6. Acknowledgments
      7. About the Author
      8. Acknowledgments
      9. About the Reviewers
      10. 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
      11. Preface
        1. What this book covers
        2. What you need for this book
        3. Who this book is for
        4. Conventions
        5. Reader feedback
        6. Customer support
          1. Downloading the example code
          2. Downloading the color images of this book
          3. Errata
          4. Piracy
          5. Questions
      12. 1. Staying in Control
        1. Introduction
          1. Understanding the dashboard workspace
        2. Using the Object Browser
          1. Getting ready
          2. How to do it...
          3. How it works...
        3. Searching for components
          1. Getting ready
          2. How to do it…
          3. How it works…
        4. Grouping the canvas components
          1. Getting ready
          2. How to do it...
          3. How it works...
        5. Making the spreadsheet more readable with colors
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        6. Making the spreadsheet more readable with comments
          1. Getting ready
          2. How to do it...
          3. How it works...
        7. Making the spreadsheet more readable with borders
          1. Getting ready
          2. How to do it...
          3. There's more...
            1. Using the toolbar border button
            2. Using multiple worksheets
            3. Placing your Excel logic wisely
        8. Using named ranges
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Defined named ranges
            2. The Name Manager
        9. Copying the format of one cell to another cell or range
          1. How to do it...
          2. How it works...
          3. There's more...
        10. Debugging the spreadsheets
          1. How to do it...
          2. How it works...
          3. There's more...
        11. Navigating between worksheets
          1. How to do it...
          2. How it works...
      13. 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
              1. Bar chart and column chart
              2. Area chart
              3. Stacked charts
              4. Marimekko chart
        3. Using a bullet chart
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        4. Using sparklines
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Header labels
            2. Low and high values
        5. Using a combination chart
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        6. Using a waterfall chart
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        7. Using a pie chart
          1. Getting ready
          2. How to do it...
          3. How it works...
        8. Using a scatter plot chart
          1. Getting ready
          2. How to do it...
          3. How it works...
        9. Using a bubble plot chart
          1. Getting ready
          2. How to do it...
          3. How it works...
        10. Using a radar chart
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        11. Using an OHLC chart and a candlestick chart
          1. Getting ready
          2. How to do it...
          3. How it works...
        12. Sorting series
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        13. Zooming in on charts
          1. Getting ready
          2. How to do it...
          3. How it works...
        14. Scaling the y-axis
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Variable maximum limits
            2. Allow Zoom Out Only
        15. Using a tree map
          1. Getting ready
          2. How to do it...
          3. How it works...
        16. Showing a trend without a chart
          1. Getting ready
          2. How to do it...
          3. How it works...
        17. Displaying raw data
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        18. Illustrating single values
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
      14. 3. From a Static to an Interactive Dashboard
        1. Introduction
        2. 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
        3. Drilling down from a chart
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        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. An alternative hierarchy selection method
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        6. Using the Hierarchical Table
          1. Getting ready
          2. How to do it…
          3. How it works...
          4. There's more…
        7. Using Filtered Rows
          1. How to do it...
          2. How it works...
        8. Using maps to select data of an area or country
          1. How to do it...
          2. How it works...
          3. There's more...
        9. Adding a Mac OS X-looking dock to your dashboard
          1. How to do it...
          2. How it works...
          3. There's more...
        10. Resetting your data (the reset button)
          1. How to do it...
          2. How it works...
        11. Making selections from a custom image (the push button and image component)
          1. How to do it...
          2. How it works...
          3. See also
        12. Inputting data values
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        13. Using the Play Selector / Play Control component
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        14. 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
        15. Selecting calendar dates
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        16. Using sliders to create a what-if scenario
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
      15. 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...
        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 mouseover help text popup
          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...
      16. 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. There's more...
        3. Making alert ranges dynamic
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        4. Displaying alerts on a map
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        5. Displaying alerts of different thresholds on a map
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        6. 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
        7. Using alerts in a Scorecard
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
      17. 6. Advanced Components
        1. Introduction
        2. Printing your dashboard
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        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's more...
        5. Using the Grid component
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        6. Creating a slideshow
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        7. Using the Panel Set component
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's 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. Inserting data 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's more...
      18. 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...
        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. Dynamic XY positioning and sizing of components
          1. Getting ready
          2. How to do it…
          3. There's more…
        9. Using the Panel Container
          1. How to do it...
          2. How it works...
          3. There's more...
        10. Using the Tab Set container
          1. How to do it...
          2. How it works...
          3. There's more...
        11. Making tables look pretty
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        12. Using quadrants smartly
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        13. Creating/using a dashboard template
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
      19. 8. Dashboard Data 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's more...
            1. Usage tab
            2. Connection Refresh Button
        3. Using Query as a Web Service (QaaWS)
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's 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's more...
        5. Using BI Web Services to consume a Webi report
          1. Getting ready
          2. How to do it...
            1. Creating the BI Web Service
            2. Creating a BI Web Service connection in SAP BusinessObjects Dashboards
          3. How it works…
          4. There's more…
        6. Using the SAP NetWeaver BW Connection
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Using variables and filters
            2. Other Output Values
            3. Returned data format
        7. Using the Query Browser
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Query Refresh Button
            2. SAP BW BEx Query
            3. Using SAP HANA as a data source
            4. Using SAP ECC tables as a data source
        8. Passing values from dashboard to dashboard with Flash Variables
          1. How to do it...
          2. How it works...
          3. There's more...
      20. 9. Exporting and Publishing
        1. Introduction
        2. Exporting to SWF, PPT, PDF, and other file types
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        3. Publishing to SAP BusinessObjects BI Platform
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        4. Housing your dashboard in a BI Workspace
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Setting a BI Workspace as a home tab for BI Launchpad
            2. Support for other types of BI documents
            3. Content linking
        5. Publishing to SAP BW
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        6. Going mobile
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. The Mobile Compatibility panel
            2. Sharing and annotating dashboards from the SAP BusinessObjects Mobile app
      21. 10. Top Third-party Add-ons
        1. Introduction
        2. Managing add-ons in SAP BusinessObjects Dashboards
          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's more...
        4. Integrating Google Maps with the CMaps plugin
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        5. Connecting to Salesforce.com with DashConn
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Salesforce.com Data Manager Connection
            2. Working Mode settings
        6. Presenting micro charts in a Tree Grid
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        7. Integrating Web Intelligence with Antivia XWIS Advantage Express
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. XWIS Slice and Dice component
            2. XWIS Export component
            3. Alerts
            4. Antivia Timer component
        8. Advanced printing with Xcelsius Dashboard Printer
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        9. SUCCESS with graphomate charts
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
      22. 11. Performance Tuning
        1. Introduction
        2. Improving Excel spreadsheet performance
          1. How to do it…
        3. Using scheduled Webis to save on querying time
          1. Getting ready
          2. How to do it…
          3. How it works…
        4. Running connections after loading the dashboard
          1. Getting ready
          2. How to do it…
          3. How it works…
        5. Checking master data loading performance of connections
          1. Getting ready
          2. How to do it…
          3. There's more…
        6. Optimizing BEx Query performance
          1. How to do it…
            1. Use dashboard specific queries
            2. Use the BEx Query Designer features
            3. Only use and reload necessary (master) data
        7. Using Fiddler to identify the cause of performance issues
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
          5. See also
      23. 12. Increasing Productivity
        1. Introduction
        2. Using the Spreadsheet Table component to debug
          1. Getting ready
          2. How to do it…
          3. How it works…
        3. Time-saving tips during dashboard development
          1. How to do it…
            1. Global Fonts
            2. Grouping from the Object Browser versus grouping with a Canvas Container
            3. Editing multiple components at once
            4. Using the alignment, sizing, and spacing buttons
            5. Using the arrow keys for precise placement of components
            6. Using the Grid to help with relative positioning
            7. Copying objects from another dashboard
        4. Fixing corrupt XLF files
          1. Getting ready
          2. How to do it…
          3. How it works…
          4. There's more…
      24. 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...
      25. B. Additional Resources – Supported Excel Functions and System/Software Requirements
        1. Online resources
        2. Supported Excel functions
        3. System and software requirements
      26. C. The Future of Dashboarding with SAP Design Studio
        1. What is SAP BusinessObjects Design Studio?
        2. SAP BusinessObjects Dashboards versus SAP BusinessObjects Design Studio
        3. What is the SAP roadmap for dashboarding?
      27. Index