Changing the nesting order

When you create a visualization in an IBM® Cognos® Active Report, you can change the nesting order so that extra items are ordered properly in the query. If the items are not ordered properly in the query, the report might not run.

About this task

Extra items are data items that are used for filtering or setting variables. These items are not visible in the visualization. By default, extra categories are nested below other categories, so as not to affect sorting. However, if the extra categories are from the same dimension as a category, they must be in the correct hierarchical order: Years, Quarters, and Months. You can change the nesting order.

For example, you have Quarters and Months as categories. You then add Years as an extra category. You add an Active Report control and connect to Years as a filter. You might have to change the nesting order of the data items for the report to run.

Note: Extra items are available only when you choose to render the visualization on the client. You cannot add extra items to a visualization when you choose to render the visualization on the IBM Cognos server.

Procedure

Select the data container that contains the data set in which you want to change the nesting order.
From the Properties pane, under General, click Change Nesting Order.
In the Change Nesting Order window, select the extra category and use the arrow icon to reorder it.
Tip: You can click Show Data Container to view the new nesting order when the report is run.