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

Inserting data with the Source Data component


The Source Data component enables us to insert data into spreadsheet cells by changing the selected index value of the component. This is a different approach to inserting data than the one we saw in Chapter 3, From a Static to an Interactive Dashboard, when we were discussing selectors and drilldowns.

Getting ready

Open a new SAP BusinessObjects Dashboard file and enter the following data into the spreadsheet:

How to do it...

  1. Drag a Pie Chart component into the canvas.

  2. Bind the Chart field to cell B3 and leave the Subtitle field empty.

  3. Bind the Data | Values field to the spreadsheet range from C3 to E3. Select the Data in Rows option.

  4. Bind the Labels field to cells C5 to E5.

  5. Drag a Horizontal Slider component to the canvas.

  6. Bind the Data field to cell B1.

  7. Set Minimum Limit to 0 and Maximum Limit to 3.

  8. Now drag the Source Data component into the canvas:

  9. Set Insertion Type as Row.

  10. Bind the Source Data field to cell range B6:E9.

  11. Bind the Destination field to...