Using the Hierarchical Table

The Hierarchical Table is a powerful component that was introduced in SAP BusinessObjects Dashboards 4.0 FP3. It allows users to connect to either a BEx query connection or an OLAP universe and take advantage of its hierarchical display and multi-selection capability.

Before the Hierarchical Table was introduced, there was no way to accomplish native hierarchical display and selection without significant workarounds.

Note

Although the Hierarchical Table component is extremely powerful, please note that it can only be used with either a BEx query or an OLAP universe. It will not work on a universe based on a relational database.

Getting ready

Before you can take advantage of the Hierarchical Table component, you must have an OLAP universe or a BEx query connection available. In our example, we create a simple cube from the Adventureworks data warehouse, which is easily accessible from MSDN.

You can download the Adventureworks data warehouse available at http://msftdbprodsamples...