Sorting Dimensional Data
For more information about data modeling, see the IBM Cognos Framework Manager User Guide.
Limitations When Sorting SAP BW Data
If you use a SAP BW data source, each level in a hierarchy has an item with the same name as the level and a role of _businessKey. Such items are known as level identifiers. You should use only the level identifier of all the time-related characteristics, such as 0CALDAY and 0CALMONTH, for sorting. All other (attribute) items in these hierarchies are formatted string representations of the characteristic values with which they are associated. These formatted values sort alphanumerically and not chronologically.