Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

By : David Lai
Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

By: David Lai

Overview of this book

If you are a developer with a good command and knowledge of creating dashboards, but are not yet an advanced user of SAP BusinessObjects Dashboards, then this is the perfect book for you. Prerequisites include a good working knowledge of Microsoft Excel as well as knowledge of basic dashboard practices.
Table of Contents (17 chapters)
16
Index

Using Filtered Rows


Filtered Rows was one of the greatest additions to Xcelsius 2008 (now SAP BusinessObjects Dashboards 4.1) from Xcelsius 4.5. If we look at the following screenshot, we see that we have a set of Sales metrics that are grouped by Region and Office:

Let's say we want to be able to select a region and show a sales comparison chart between the different sales offices of that region. Before the advent of Filtered Rows, we would have had to perform a complex VLOOKUP or have the result come back through a query every time a region was selected. Both methods are very time consuming.

How to do it...

  1. We will use a Combo Box selector to choose the desired region.

  2. In the Combo Box selector properties, bind the Labels to the Region column.

  3. Select Filtered Rows as the Insertion Type. Bind Source Data to cells A3:C12. The Destination will contain the chart values as well as the selected region.

  4. Bind the chart values to the Destination section from step 3.

How it works...

The Filtered Rows insertion...