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

Making the spreadsheet more readable with comments


Sometimes cells need additional information to explain how they are used. Of course you can write this text as a label in another spreadsheet cell, but a better solution is to use comments.

Getting ready

You can use the same basic dashboard as for the previous recipe.

How to do it...

  1. Right-click the cell to which you want to add the extra information.

  2. Choose Insert Comment.

  3. Add your text. A small red rectangle will appear in the right upper corner of the cell.

  4. Now hover your mouse over the cell and the comment you just entered will appear.

How it works...

Comments are related to one spreadsheet cell only and are only shown if you hover the mouse over this cell. This is a great way to document information that you do not need to see all the time, which keeps your data model clean.

A good case to use this is when you are building a dashboard with multiple layers in combination with dynamic visibility. You might use numbers to identify each layer and use a cell to contain the number of the active layer. You can use a comment to describe the meaning of these cell values.

A little remark about the usage of comments is that they do increase the size of the Dashboard Design file a bit.