SAP BusinessObjects Dashboards 4.0 Cookbook

SAP BusinessObjects Dashboards 4.0 Cookbook

Overview of this book

Xcelsius 2008 was recently included in SAP’s BusinessObjects 4.0 family, rebranding “Xcelsius Enterprise” as “SAP BusinessObjects Dashboards 4.0”. With features like flexible design and what-if scenarios, the powerful dashboarding software allows enterprises to make business decisions at a glance, and this book allows you to go far beyond the basics of these techniques. This cookbook full of practical and applicable recipes will enable you to use the full latest capabilities of Dashboard Design to visually transform your business data. A wide range of recipes will equip you with the knowledge and confidence to perform tasks like configuring charts, creating drill- downs, making component colors dynamic, using alerts in maps, building pop-up screens, setting up What-If scenarios, and many more.The recipes begin by covering best practices for using the Dashboard Design spreadsheet, the data-model, and the connection with the components on the canvas, later moving on to some from-the-trenches tricks for using Excel within Dashboard Design. The book then guides you through the exploration of various data visualization components and dashboard interactivity, as well as offering recipes on using alerts, dashboard connectivity, and making the most of the aesthetics of the dashboard. Finally, the recipes conclude by considering the most important add-ons available for Dashboard Design and enabling you to perform relevant and useful tasks straight away.

SAP BusinessObjects Dashboards 4.0 Cookbook

Credits

Foreword

About the Authors

Acknowledgement

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

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

Data Visualization

Introduction

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

Showing a trend without a chart

Displaying raw data

Illustrating single values

From a Static to an Interactive Dashboard

Introduction

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

Dynamic Visibility

Introduction

Switching between different charts

Building a pop-up screen

Creating a mouse-over help text pop-up

Password protecting your dashboard

Using Alerts

Introduction

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

Advanced Components

Introduction

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

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

Using the panel container

Using the tab set container

Making tables look pretty

Smart use of quadrants

Dashboard Connectivity

Introduction

Creating a news ticker with Excel XML Maps

Using Query as a WebService (QaaWS)

Using Live Office connection

Connecting to SAP BW

Using Universe queries

Passing values from dashboard to dashboard with Flash Variables

Accessing dashboards with live data outside of Infoview using CELogonToken

Exporting and Publishing

Introduction

Exporting to a standard SWF, PPT, PDF, and so on

Exporting to SAP Business Objects Enterprise

Publishing to SAP BW

Housing your dashboard in Dashboard Builder

Creating Adobe Air Applets from Dashboard Design dashboard

Top Third-Party Add-ons

Introduction

Managing add-ons in Dashboard Design

Connecting to CSV-files with the CSV-connector

Integrating Google Maps with the GMaps plugin

Connecting to Salesforce.com with DashConn

Transferring data between dashboards with Data Sharer

Presenting micro charts in a tree grid

Integrating Web Intelligence with Antivia XWIS

Real World Dashboard Case Studies

What-if scenario: mortgage calculator

Sales/profit dashboard example

Additional Resources—Supported Excel Functions and System/Software Requirements

Online resources

Supported Excel functions

System and software requirements

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Using sparklines

Sparklines are typically small graphics, showing a horizontal line connecting several data points without labeling the values on its axes. The purpose of the sparkline is to show the movement of a trend over a certain period. Since its details are not available, the context of a sparkline must be clear to the dashboard user to interpret its meaning properly. This recipe will show you how to configure a sparkline.

Getting ready

Open a new Dashboard Design file and enter the data into the spreadsheet, as shown in the following screenshot:

How to do it...

Drag a Sparkline Chart component into the canvas.
Bind the By Range field to the spreadsheet range from A4 to M5.
Bind the Chart field to cell A1 and bind the Subtitle field to cell A2.
Go to the Behavior tab of the properties pane of the Sparkline Chart component. In the Normal Range Area section, select Normal Range Area.
Enter the value 600 in the Normal Range Low field and enter 1000 in the Normal Range High field.
Go to the Appearance...

SAP BusinessObjects Dashboards 4.0 Cookbook

SAP BusinessObjects Dashboards 4.0 Cookbook

Overview of this book

Related Content you might be interested in

Current Title:

SAP BusinessObjects Dashboards 4.0 Cookbook

Using sparklines

Getting ready

How to do it...