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
Preview in Mapt

SAP BusinessObjects Dashboards 4.1 Cookbook

David Lai, Xavier Hacking

1 customer reviews
Over 100 simple and incredibly effective recipes to help transform your static business data into exciting dashboards filled with dynamic charts and graphics
Mapt Subscription
FREE
$29.99/m after trial
eBook
$28.00
RRP $39.99
Save 29%
Print + eBook
$49.99
RRP $49.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$28.00
$49.99
$29.99p/m after trial
RRP $39.99
RRP $49.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


SAP BusinessObjects Dashboards 4.1 Cookbook Book Cover
SAP BusinessObjects Dashboards 4.1 Cookbook
$ 39.99
$ 28.00
SAP BusinessObjects Dashboards 4.0 Cookbook Book Cover
SAP BusinessObjects Dashboards 4.0 Cookbook
$ 32.99
$ 23.10
Buy 2 for $35.00
Save $37.98
Add to Cart
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 

Book Details

ISBN 139781784391959
Paperback452 pages

Book Description

The widely used SAP BusinessObjects Dashboards software lets you transform data from any source into interactive dashboards.

The recipes begin by covering best practices for using the SAP BusinessObjects Dashboards spreadsheet. The book then guides you through the exploration of various data visualization components and dashboard interactivity, as well as using alerts, dashboard connectivity, publishing the dashboard, and making the most of the aesthetics of the dashboard. Finally, the recipes conclude by considering the most important add-ons available for SAP BusinessObjects Dashboards, performance tuning, and tips on increasing development productivity.

Table of Contents

Chapter 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
Chapter 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
Chapter 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
Chapter 4: Dynamic Visibility
Introduction
Switching between different charts
Building a pop-up screen
Creating a mouseover help text popup
Password protecting your dashboard
Chapter 5: Using Alerts
Introduction
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
Chapter 6: Advanced Components
Introduction
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
Chapter 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
Chapter 8: Dashboard Data Connectivity
Introduction
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
Chapter 9: Exporting and Publishing
Introduction
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
Chapter 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
Chapter 11: Performance Tuning
Introduction
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
Chapter 12: Increasing Productivity
Introduction
Using the Spreadsheet Table component to debug
Time-saving tips during dashboard development
Fixing corrupt XLF files

What You Will Learn

  • 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

Authors

Table of Contents

Chapter 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
Chapter 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
Chapter 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
Chapter 4: Dynamic Visibility
Introduction
Switching between different charts
Building a pop-up screen
Creating a mouseover help text popup
Password protecting your dashboard
Chapter 5: Using Alerts
Introduction
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
Chapter 6: Advanced Components
Introduction
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
Chapter 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
Chapter 8: Dashboard Data Connectivity
Introduction
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
Chapter 9: Exporting and Publishing
Introduction
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
Chapter 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
Chapter 11: Performance Tuning
Introduction
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
Chapter 12: Increasing Productivity
Introduction
Using the Spreadsheet Table component to debug
Time-saving tips during dashboard development
Fixing corrupt XLF files

Book Details

ISBN 139781784391959
Paperback452 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

SAP HANA Cookbook Book Cover
SAP HANA Cookbook
$ 29.99
$ 21.00
SAP BusinessObjects Reporting Cookbook Book Cover
SAP BusinessObjects Reporting Cookbook
$ 32.99
$ 23.10
Creating Universes with SAP BusinessObjects Book Cover
Creating Universes with SAP BusinessObjects
$ 32.99
$ 23.10
QlikView for Developers Cookbook Book Cover
QlikView for Developers Cookbook
$ 26.99
$ 18.90
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial Book Cover
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
$ 35.99
$ 25.20
Learning QlikView Data Visualization Book Cover
Learning QlikView Data Visualization
$ 22.99
$ 16.10