Alternative hierarchy selection method

When navigating through a hierarchy selection, it is often that a user wants to see a list of available parents or children instead of only being able to see one at a time when looking at drop-down filters. Here is an alternative using the more complex listbox breadcrumb type approach for three levels:

Alternative hierarchy selection method

Getting ready

Set up the data as shown next. The blue section contains the initial full hierarchical data. The yellow section contains each breadcrumb trail whose source is one column less than the parent. More about how everything works will be explained in the How it Works section.

How to do it...

  1. Insert three ...

Get SAP BusinessObjects Dashboards 4.0 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.