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

Using maps to select data of an area or country


Maps are commonly used in dashboards to visually identify areas or regions. Using maps on a dashboard allows us to visually identify using a picture instead of a table/chart and see, for example, which regions are doing poorly versus which regions are doing well. As you can see looking at the map of Canada, users are able to visually distinguish between each province.

How to do it...

  1. Select a map component from the Maps section. In our example, we will use Canada.

  2. In the map properties, you will need to bind the region keys appropriately, as shown in the following spreadsheet:

    Tip

    Tip for finding the map regions

    A full list of the region keys for each map included in Dashboard Design can be found in the MapRegions.xls spreadsheet in the <install path>\Xcelsius\assets\samples\User Guide Samples\ directory.

  3. Next, bind the Display data which will be the key/value pair. The key comes from the key that you used in step 2 and the value can be any...