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

Using the Filter selector component for hierarchies


SAP BusinessObjects Dashboards provides an easy-to-use selector component for hierarchical data. For example, we may have a hierarchy that consists of a Region, Sales District, and Sales Office. We can easily create this with the Filter component.

Getting ready

It is important to set up the data as shown in the following screenshot so that the Filter component can consume it properly. Every row has to have values for the Region, Sales District, and Sales Office as well as the metric value(s) that you want populated on your destination. We have highlighted the destination in F3 and the filter-related stuff in A3:C6 and D3:D6. Information on how everything works can be found in the How it works... section.

How to do it...

  1. Add a Filter component from the Selectors category onto the canvas. In the Properties window, set Number of Filters to 3 since our hierarchy has three levels.

  2. Bind the Source Data to the area in green (A3:D6) from the data setup...