HOT TIP: Allowing User Selection of a Hierarchy in a Report Studio Report
By Michael Vilhauer, Consultant, Brightstar Partners

Allowing users to change a hierarchy used in a Report Studio report while maintaining the drill-up and drill-down capabilities from a DMR or cube data source may seem very difficult to achieve. This article outlines how to achieve this user functionality in both manageable and relatively simple steps using a prompt page and Cognos macros.  
 
For detailed steps for how to create this user on-demand hierarchy maintaining the drill-up and drill down functionality in a report in Cognos 8, click here.