Book Image

SAP BusinessObjects Dashboards 4.0 Cookbook

Book Image

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.
Table of Contents (22 chapters)
SAP BusinessObjects Dashboards 4.0 Cookbook
Credits
Foreword
About the Authors
Acknowledgement
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Index

Displaying raw data


If you want to display numbers and text, and not by a chart, but just in a table, you can use the spreadsheet table component.

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...

  1. In the spreadsheet, select cells A4 through E4.

  2. Add a Bottom Border by using the Borders menu of the Font section of the Home tab in the spreadsheet.

  3. Select cells A4 through A7 and add a Right Border.

  4. Drag a Spreadsheet Table component into the canvas.

  5. Bind the Display Data field with the spreadsheet range from A4 to E7.

  6. Go to the Behavior tab and deselect Row in the Row Selectability section.

  7. Go to the Appearance tab and deselect Show Gridlines in the Layout sub-tab.

  8. The dashboard should now look like the following screenshot:

How it works...

The spreadsheet table component shows a range of cells exactly as they are formatted in the spreadsheet. You can add borders, colors, change fonts, alignments, and so on. If you...