- SAP BusinessObjects Dashboards 4.1 Cookbook
- Table of Contents
- SAP BusinessObjects Dashboards 4.1 Cookbook
- Credits
- Foreword
- About the Author
- Acknowledgments
- About the Author
- Acknowledgments
- About the Reviewers
- www.PacktPub.com
- Preface
- 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
- 5. Using Alerts
- 6. Advanced Components
- 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
- 9. Exporting and Publishing
- 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
- 12. Increasing Productivity
- Introduction
- Using the Spreadsheet Table component to debug
- Time-saving tips during dashboard development
- How to do it…
- Global Fonts
- Grouping from the Object Browser versus grouping with a Canvas Container
- Editing multiple components at once
- Using the alignment, sizing, and spacing buttons
- Using the arrow keys for precise placement of components
- Using the Grid to help with relative positioning
- Copying objects from another dashboard
- How to do it…
- Fixing corrupt XLF files
- A. Real-world Dashboard Case Studies
- B. Additional Resources – Supported Excel Functions and System/Software Requirements
- C. The Future of Dashboarding with SAP Design Studio
- Index
With SAP BusinessObjects Dashboards, we can create tables that look just like a table in an Excel spreadsheet. Unfortunately, our everyday tables look quite bland. If we start off with a default spreadsheet table, it will look kind of like this:
It looks okay, but with the help of some additional objects, we can spice it up to look a bit more attractive.
Prepare the data on your Excel spreadsheet and set up a Spreadsheet Table component as shown in the previous screenshot.
- Add color to the row header, and make the header text bold.
- In the Spreadsheet Table component properties, rebind Display Data to the corresponding cells (A1:F15) so that the updated header text format will show up. Go to the Appearance category and uncheck Show Gridlines.
- Change the theme to Aero.
- Select the first Background object from the Art and Backgrounds tab from the Category window. Place the background so that it is under the table.
- Select Label from the Text tab of the Category window. Center it on the title background to give the table a title.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.