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...