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