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

Drilling down from a chart


Being able to drill down from higher-level data to more granular data is a very important feature in SAP BusinessObjects Dashboards. We want to be able to retrieve high-level and granular-level data easily without hunting for it. By using drilldowns, users can easily navigate through the different levels of data.

Getting ready

Insert two charts into the canvas (Parent = Column Chart; Child = Line Chart). Data in the child chart is driven from the parent chart.

Tip

Please refer to the example Drilling down from a chart.xlf from the code bundle on how to set up and bind data appropriately to the charts.

How to do it...

  1. In our example, the parent chart contains Regional Sales information. The child chart contains a drilldown of a monthly trend.

  2. Turn on the drilldown capability from the parent chart by clicking on the Insertion icon and then on the Enable Data Insertion checkbox.

  3. Select the Insertion Type that you will use for the drilldown bars. In our case, we will drill...