SAP BusinessObjects Dashboards 4.1 Cookbook
Over 100 simple and incredibly effective recipes to help transform your static business data into exciting dashboards filled with dynamic charts and graphics with SAP BusinessObjects Dashboards 4.1 (Xcelsius)
In this updated version of the SAP BusinessObjects Dashboards cookbook we broadened the scope a bit for the beginning SAP BusinessObjects Dashboards developer as well for the more experienced user. We now provide some more introduction to the SAP BusinessObjects Dashboards tool itself before diving into the practical step-by-step recipes right from the start. For the more seasoned users we added chapters about dashboard performance tuning and development productivity, plus a bunch of new tips & tricks throughout the book.
The original cookbook was released almost five years ago and covered version 4.0 of SAP BusinessObjects Dashboards. The second edition is updated up to the latest version of SAP BusinessObjects Dashboards 4.1. Together with a team of technical reviewers, existing of some world class SAP BusinessObjects Dashboards developers, we checked the existing content from the first cookbook on its relevance, correctness and completeness. Most recipes have been updated, some a bit more than others, and we decided to keep a few of them out of the new book.
Of course we also added a lot of new recipes to feature the new 4.1 features and include more tips & tricks. We discuss all the new components, the new mobile dashboards concept and the new connectivity options, complemented with new chapters on performance tuning and development productivity. At the end of the book the other dashboarding solution by SAP (Design Studio) is introduced.
With about 100 recipes and over 450 pages of content (100 pages more than the first edition) this is thé ultimate and definite guide for SAP BusinessObjects Dashboards 4.1 developers!
To learn more about the book you can read the FAQ below.
SAP BusinessObjects Dashboards 4.1 Cookbook, by Xavier Hacking and David Lai, Packt Publishing, ISBN 9781784391959, 452 pages.
SAP BusinessObjects Dashboards 4.1 Cookbook FAQ
- Create impressive dashboards with SAP BusinessObjects Dashboards 4.1 (formerly known as Xcelsius)
- Find solutions for everyday development challenges using Dashboard Design components
- Step-by-step recipes with practical real-world examples
If you are a developer with a good command and knowledge of creating dashboards, but are not yet an advanced user of SAP BusinessObjects Dashboards, then this is the perfect book for you. Prerequisites include a good working knowledge of Microsoft Excel as well as knowledge of basic dashboard practices.
This guide to SAP BusinessObjects Dashboards 4.1 (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. The reader will be guided by a step-by-step method to accomplish specific tasks.
Each recipe is supported by a large number of screenshots and for most of the recipes we included XLF source files for even better understanding. Throughout the book you will find lots of tips, tricks and best practices.
- Become fully equipped with best practices when using the SAP BusinessObjects Dashboards spreadsheet
- Present data using a wide variety of data visualization components
- Discover how to make dashboard components interactive for an enhanced user experience
- Take advantage of Dynamic Visibility features
- Connect your dashboard to live data sources
- Export and publish the SAP BusinessObjects Dashboards model into several environments
- Improve the performance of your dashboards and increase your productivity as a dashboard developer
At Packt Publishing you won’t have to pay shipping costs and you can also get the eBook version here.
Yes! At Packt Publishing you can also get the eBook version of the cookbook.
- The eBook is available in PDF, ePub, Mobi and Kindle format.
- You can download Packt eBooks from your Packtpub.com account as many times as you like.
- Packt eBooks are DRM free and you can copy and paste from them.
- You can also read the book online without the need to download.
We included a lot of XLF source files and SWF files to support the recipes in the book. You can download these files freely from the PacktPub website or from your PacktPub account page.
- 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
- 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
- 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
- Switching between different charts
- Building a pop-up screen
- Creating a mouseover help text popup
- Password protecting your dashboard
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Using the Spreadsheet Table component to debug
- Time-saving tips during dashboard development
- Fixing corrupt XLF files
Related HackingSAP.com blogposts
[catlist name=cookbook date=yes excerpt=yes numberposts=-1]