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

Debugging the spreadsheets

It is common that SAP BusinessObjects Dashboards developers may accidently put in the incorrect formula when developing logic on their spreadsheets. Using the Ctrl + ` hotkey will make things much easier.

How to do it...

  1. Select the worksheet you want to see formulas for.
  2. Hit the Ctrl + ` (grave accent) hotkey.
  3. You will see the value in the cell change to the formula.

How it works...

The Ctrl + ` hotkey works by showing the underlying formula of a cell. This is extremely useful if you are comparing formulas from multiple cells, as the developer does not have to flip between formulas in order to see what they are doing wrong when comparing multiple cells. Developers can quickly analyze their worksheet and find the cause of their problem.

The following screenshot shows the results of two Excel formulas in cells A1 and A2:

How it works...

After using the Ctrl + ` hotkey, the formulas of both cells are displayed, as you can see in the next screenshot:

How it works...

There's more...

An alternative way to accomplish the same task is to go to the Formula Auditing section of the Formulas tab and then click on Show Formulas. Refer to the following screenshot:

There's more...