Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

Overview of this book

Table of Contents (26 chapters)
SAP BusinessObjects Dashboards 4.1 Cookbook
Credits
Foreword
About the Author
Acknowledgments
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
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...