更新时间:2021-04-02 19:30:57
封面
版权信息
Credits
Foreword
About the Authors
Acknowledgement
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
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
Chapter 1. Staying in Control
Introduction
Making 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
Chapter 2. Data Visualization
Adding 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
Chapter 3. From a Static to an Interactive Dashboard
Drilling 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
Chapter 4. Dynamic Visibility
Switching between different charts
Building a pop-up screen
Creating a mouse-over help text pop-up
Password protecting your dashboard
Chapter 5. Using Alerts
Adding 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
Chapter 6. Advanced Components
Printing 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
Chapter 7. Dashboard Look and Feel
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
Using the panel container
Using the tab set container
Making tables look pretty