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

Switching between different charts

This recipe will show you how to create a dashboard with the option of switching between two charts.

Getting ready

Open a new SAP BusinessObjects Dashboards file and drag two different chart components (for example, a Line Chart and a Pie Chart component) into the empty canvas. Drag the Label Based Menu component found in Selectors into the canvas as well.

How to do it...

  1. Click on the Line Chart component and go to the Behavior tab of its properties pane. At the bottom of the pane, you will see a section called Dynamic Visibility.
  2. Bind the Status field to spreadsheet cell B1.
  3. Put value 1 in the Key field:
    How to do it...
  4. Click on the Pie Chart component and go to the Behavior tab.
  5. Here also, bind the Status field to cell B1.
  6. In the Key field, fill in the value 2:
    How to do it...
  7. Go to the spreadsheet and type Status: in cell A1 and put value 1 in cell B1:
    How to do it...
  8. Now click on the Label Based Menu component and go to the General tab of its properties pane.
  9. To set the Labels, click on the button on the extreme...