Hacking Xavier, Lai David. SAP BusinessObjects Dashboards 4.0 Cookbook

Birmingham - Mubai: Packt Publishing, 2011. — 334 p. — ISBN: 978-1-849681-78-0.Over 90 simple and incredibly effective recipes for transforming your business data into exciting dashboards with SAP BusinessObjects Dashboards 4.0 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. 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.Staying in ControlMaking 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
Data VisualizationAdding 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
From a Static to an Interactive DashboardDrilling 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
Dynamic VisibilitySwitching between different charts
Building a pop-up screen
Creating a mouse-over help text pop-up
Password protecting your dashboard
Using AlertsAdding 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
Advanced ComponentsPrinting 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
Dashboard Look and FeelChanging 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
Dashboard ConnectivityCreating 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
Exporting and PublishingExporting 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
Top Third-Party Add-onsManaging add-ons in Dashboard Design
Connecting to CSV-files with the CSV-connector
Integrating Google Maps with the GMaps plugin
Connecting to Salesforce.com with DashConn
Transferring data between dashboards with Data Sharer
Presenting micro charts in a tree grid
Integrating Web Intelligence with Antivia XWIS
Appendix A: Real World Dashboard Case Studies
What-if scenario: mortgage calculator
Sales/profit dashboard example
Appendix B: Additional Resources — Supported Excel Functions
and System/Software Requirements
Online resources
Supported Excel functions
System and software requirements