Level selection from a combo box
We will add a combo box to the sample ABC Analysis report supplied with the Best Practices Templates database. The combo box will display the levels of the Product hierarchy (All, Product Group, Tire and Size). These levels are elements of the Olap Metadata hierarchy.
To see this, open Accessories in the Repository Explorer and expand Custom Hierarchies. select Olap Metadata and click
. The hierarchy is displayed in the Preview pane of the List Designer. Expand . The four product levels are displayed.The report currently displays products at the Product Name level of the hierarchy. But, by selecting a level from the combo box, users will choose the level at which the data is displayed.