Insert a Hierarchy
You can quickly insert entire hierarchies in a report.
When using an IBM® Cognos® PowerCube, a SSAS cube, or a dimensionally-modeled relational data source, you can insert multiple hierarchies from the same dimension in a crosstab. For example, you can place one hierarchy from a dimension on an edge of the crosstab and nest another hierarchy from the same dimension on the same edge, on another edge, or in the Context filter area.
You can also perform arithmetic, percentage, and ranking calculations using multiple hierarchies.
Summary or analytic calculations that refer to different hierarchies from the same dimension, such as total, count, average, minimum, and maximum, are not supported. These calculations cause an OP-ERR-0250 error.