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 using borders


To separate cells from each other and create different areas within a spreadsheet, you can use cell borders.

Getting ready

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

How to do it...

  1. Select the cell(s) you want to add a border to and right-click.

  2. Now select Format cells....

  3. Go to the Border tab.

  4. Select the desired style of the border line.

  5. Select on which side(s) of the cell(s) the border should appear.

  6. Click on OK.

There's more...

Toolbar border button

Instead of right-clicking the cells and using the Format Cells option you can also use the Border button on the toolbar to adjust the border styles for a cell or a group of cells. You can find this Border button in the Font section of the Home tab. If you select the cell(s) and click on this button, a list of options will be shown, which you can choose from.

Use multiple worksheets

You can use borders to split data within a spreadsheet. But if your Dashboard Design dashboard contains data from a lot of different (functional) areas, it is recommended that you split your spreadsheet in several sheets. This will help you to keep your dashboard maintainable.

A good strategy to split up the spreadsheet is to divide your data in different areas that correspond to certain areas, layers, or tabs that you created on the dashboard canvas. You can also use separate sheets for each external data connection. Give each worksheet a meaningful name.

Place your logic wisely

Another general guideline is to place as many cells with logic and Dashboard Design interactivity functionality at the top left of the spreadsheet. This place is easy to reach without a lot of annoying scrolling and searching. Even more importantly, your data set may grow (vertically and/or horizontally) over time. This can especially be a risk when you are using an external data connection, and you don't want your logic to be overwritten.