Table of Contents

1: 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
  • 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
  • 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
  • Introduction
  • Switching between different charts
  • Building a pop-up screen
  • Creating a mouseover help text popup
  • Password protecting your dashboard
5: 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Introduction
  • Using the Spreadsheet Table component to debug
  • Time-saving tips during dashboard development
  • Fixing corrupt XLF files

Posted in: SAP BusinessObjects Dashboards 4.1 Cookbook FAQ