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.
Open a new SAP BusinessObjects Dashboard file and enter the following data into the spreadsheet:
0
and Maximum Limit to 3
.As mentioned in the introduction of this recipe, the Source Data component has the same data insertion functionality as selector components and drilldowns from charts. But, the data insertion of the Source Data component is triggered by a changing value in a spreadsheet cell and not directly by a user interacting with a component.
In this recipe, we used the Horizontal Slider component to change a cell value (cell B1) to trigger the data insertion. But you can, of course, also use this component in combination with Excel formulas, Dynamic Visibility, or the data inserted by other components.