Sort measures and folders

In IBM® Cognos® Cube Designer, you can change the order in which measures, calculated measures, and folders are sorted within a measure dimension. You can also sort objects within a specific folder.

The default sort order for dynamic cubes is the order that is shown in the measure dimension. You can change the order by manually moving objects to any position that you require. You can also sort objects in ascending or descending alphanumeric order. Sorting applies within a single level of nesting only. If a folder contains sub folders, they are not included in an alphanumeric sort.

Important: The default sort order for dynamic cubes that are published with previous versions of Cognos Cube Designer is ascending alphanumeric order. If you update or republish the cube with version 10.2.1.1, it overrides the previous sort order with the new default order.

Cognos Cube Designer sorts measures according to the project design language, not the locale that is defined for measures and folders or the server content language.

Sorting in virtual cubes

You can sort measures, calculated measures, and measure folders in a virtual cube. If objects are sorted in a source cube, the sort order is not included in the virtual cube.