Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

By : David Lai
Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

By: David Lai

Overview of this book

If you are a developer with a good command and knowledge of creating dashboards, but are not yet an advanced user of SAP BusinessObjects Dashboards, then this is the perfect book for you. Prerequisites include a good working knowledge of Microsoft Excel as well as knowledge of basic dashboard practices.
Table of Contents (17 chapters)
16
Index

Making the spreadsheet more readable with comments

Sometimes, cells need additional information to explain how they are used. You can create comment text on an adjacent cell. Or, if you do not want to fill up other cells, you can right-click on the same cell and select Insert Comment.

Getting ready

You need a basic dashboard containing a few components in the canvas with some bindings to the data model in the spreadsheet. You can also just reuse the dashboard from the previous recipe.

How to do it...

  1. Right-click on the cell to which you want to add the extra information.
  2. Choose Insert Comment.
    How to do it...
  3. Add your text. A small red triangle will appear in the upper-right corner of the cell.
  4. Now hover your mouse over the cell and the comment you just entered will appear.
How to do it...

How it works...

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

A little remark about the usage of comments: they increase the size of the SAP BusinessObjects Dashboards file a bit.

Note

If you want the comment to always show up without hovering over the cell, you can right-click on the comment and then select Show/Hide Comments.