SAP BusinessObjects Dashboards 4.0 Cookbook -- Table of Contents -- SAP BusinessObjects Dashboards 4.0 Cookbook -- Credits -- Foreword -- About the Authors -- Acknowledgement -- Acknowledgement -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why subscribe? -- Free access for Packt account holders -- Instant updates on new Packt books -- Preface -- What is SAP Business Objects Dashboards (formerly Xcelsius)? -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Errata -- Piracy -- Questions -- 1. Staying in Control -- Introduction -- Making the spreadsheet more readable with colors -- Getting ready -- How to do it... -- How it works... -- There's more... -- Making the spreadsheet more readable with comments -- Getting ready -- How to do it... -- How it works... -- Making the spreadsheet more readable using borders -- Getting ready -- How to do it... -- There's more... -- Toolbar border button -- Use multiple worksheets -- Place your logic wisely -- Using named ranges -- How to do it... -- How it works... -- There is more... -- Defined named ranges -- Name Manager -- Selecting all worksheet cells with one click -- How to do it... -- How it works... -- There's more... -- Copying the formatting of one cell to another cell or range -- How to do it... -- How it works... -- There's more... -- Debugging your spreadsheets -- How to do it... -- How it works... -- There's more... -- Navigation between worksheets -- How to do it... -- How it works... -- Grouping the canvas components -- Getting ready -- How to do it... -- How it works... -- There's more... -- Hiding components -- Locking components -- 2. Data Visualization -- Introduction -- Adding a line chart to your dashboard -- Getting ready -- How to do it...

How it works... -- There's more... -- Manually binding data -- Hide/show series -- Other charts: bar chart and column chart -- Other charts: area chart -- Other charts: stacked charts -- Using the bullet chart -- Getting ready -- How to do it... -- How it works... -- There is more... -- Using sparklines -- Getting ready -- How to do it... -- How it works... -- There's more... -- Header labels -- Show low and high values -- Using the combination chart -- Getting ready -- How to do it... -- How it works... -- There is more... -- Using the pie chart -- Getting ready -- How to do it... -- How it works... -- Using the XY chart -- Getting ready -- How to do it... -- How it works... -- Using the bubble chart -- Getting ready -- How to do it... -- How it works... -- Using the radar chart -- Getting ready -- How to do it... -- How it works... -- There is more... -- Using the OHLC chart and candlestick chart -- Getting ready -- How to do it... -- How it works... -- Sorting series -- Getting ready -- How to do it... -- How it works... -- There is more... -- Zooming in on charts -- Getting ready -- How to do it... -- How it works... -- Scaling the y-axis -- Getting ready -- How to do it... -- How it works... -- There is more... -- Variable maximum limits -- Allow Zoom Out Only -- Using the tree map -- Getting ready -- How to do it... -- How it works... -- Showing a trend without a chart -- Getting ready -- How to do it... -- How it works -- Displaying raw data -- Getting ready -- How to do it... -- How it works... -- Illustrating single values -- Getting ready -- How to do it... -- How it works... -- There is more... -- Scaling -- 3. From a Static to an Interactive Dashboard -- Introduction -- Drilling down from a chart -- Getting ready -- How to do it... -- How it works... -- There's more... -- Selecting your data from a list -- Getting ready -- How to do it...

How it works... -- There's more... -- See also -- Using the Filter Selector component for hierarchies -- Getting ready -- How to do it... -- How it works... -- There's more... -- Alternative hierarchy selection method -- Getting ready -- How to do it... -- How it works... -- See also -- Using Filtered Rows -- How to do it... -- How it works... -- Using maps to select data of an area or country -- How to do it... -- How it works... -- There's more... -- Adding a MacOSX loading dock to your dashboard -- How to do it... -- How it works... -- There's more... -- Resetting your data (reset button) -- How to do it... -- How it works... -- Making selections from a custom image (push button and image component) -- How to do it... -- How it works... -- See Also -- Inputting data values -- Getting ready -- How to do it... -- How it works... -- See also -- Using Play Selector/Play Control -- Getting ready -- How to do it... -- How it works... -- See also -- Opening up a Web Intelligence report using dashboard parameters -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Selecting calendar dates -- Getting ready -- How to do it... -- How it works... -- See also -- Using sliders to create a what-if scenario -- Getting ready -- How to do it... -- How it works... -- See also -- 4. Dynamic Visibility -- Introduction -- Switching between different charts -- Getting ready -- How to do it... -- How it works... -- There's more... -- Other components -- Status values -- Building a pop-up screen -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a mouse-over help text pop-up -- Getting ready -- How to do it... -- How it works -- Password protecting your dashboard -- Getting ready -- How to do it... -- How it works... -- 5. Using Alerts -- Introduction -- Adding alerts to a column chart.

Getting ready -- How to do it... -- How it works... -- See also -- There's more... -- Using alerts in a gauge -- Getting ready -- How to do it... -- How it works... -- Making alert ranges dynamic -- Getting ready -- How to do it... -- How it works... -- There's more... -- See Also -- Displaying alerts on a map -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Displaying alerts of different thresholds on a map -- Getting ready -- How to do it... -- How it works... -- See also -- Using bindable colors to control alert coloring from a central location -- Getting ready -- How to do it... -- How it works... -- See also -- Using alerts in a scorecard -- Getting ready -- How to do it... -- How it works... -- See also -- 6. Advanced Components -- Introduction -- Printing your dashboard -- Getting ready -- How to do it... -- How it works... -- Grouping and organizing components with the canvas container -- Getting ready -- How to do it... -- How it works... -- Using dashboard scenarios -- Getting ready -- How to do it... -- How it works... -- There is more... -- Using the grid component -- Getting ready -- How to do it... -- How it works... -- There is more... -- Creating a slide show -- Getting ready -- How to do it... -- How it works... -- There is more... -- Using the panel set component -- Getting ready -- How to do it... -- How it works... -- There is more... -- Linking to files instead of embedding -- Panel behavior -- Using the history component -- Getting ready -- How to do it... -- How it works... -- There's more... -- Data insertion with the Source data component -- Getting ready -- How to do it... -- How it works... -- Analyzing trends -- Getting ready -- How to do it... -- How it works... -- There is more... -- 7. Dashboard Look and Feel -- Introduction -- Changing the look of a chart -- Getting ready.

How to do it... -- How it works... -- See also -- Adding a background to your dashboard -- Getting ready -- How to do it... -- How it works... -- There's more... -- Using color schemes -- Getting ready -- How to do it... -- How it works... -- There's more... -- Sharing a color scheme -- Getting ready -- How to do it... -- How it works... -- Working with themes -- How to do it... -- How it works... -- Making component colors dynamic -- How to do it... -- How it works... -- There's more... -- Using the panel container -- How to do it... -- How it works... -- There's more... -- Using the tab set container -- How to do it... -- How it works... -- There's more... -- Making tables look pretty -- Getting ready -- How to do it... -- How it works... -- See Also -- Smart use of quadrants -- Getting ready -- How to do it... -- How it works... -- See Also -- 8. Dashboard Connectivity -- Introduction -- Creating a news ticker with Excel XML Maps -- Getting ready -- How to do it... -- How it works... -- There is more... -- Adding the Developer tab -- Usage tab -- Connection Refresh button -- Using Query as a WebService (QaaWS) -- Getting ready -- How to do it... -- How it works... -- There is more... -- Using prompts -- Methods -- Using Live Office connection -- Getting ready -- How to do it... -- How it works... -- There is more... -- Using prompts -- Connecting to SAP BW -- Getting ready -- How to do it... -- How it works... -- There is more... -- Using variables and filters -- Other Output Values -- Returned data format -- Using Universe queries -- Getting ready -- How to do it... -- How it works... -- There is more... -- Query Prompt Selector -- Query Refresh button -- Passing values from dashboard to dashboard with Flash Variables -- Getting ready -- How to do it... -- How it works... -- There is more... -- Using multiple variables -- Passing multiple values.

Accessing dashboards with live data outside of Infoview using CELogonToken.