Data insertion 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 we saw in Chapter 3 when we were discussing selectors and drill downs.
Getting ready
Open a new dashboard design file and enter the data into the spreadsheet as shown in the following screenshot:
How to do it...
- Drag a pie chart component to the canvas.
- Bind the Chart field to cell B3 and leave the Subtitle field empty.
- Bind the Data Values field to the spreadsheet range from C3 to E3. Select the Data in Rows options.
- Bind ...
Get SAP BusinessObjects Dashboards 4.0 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
