TR2320
You are trying to sort a date level in descending order. This will create incorrect relative-time calculations. Do you want to continue?
Cognos® Transformer uses the ordered set of categories in a time dimension to perform relative time calculations for relative time categories. If you reverse the order of the categories in the time dimension by sorting them in descending order, Cognos Transformer is no longer able to perform relative time calculations correctly.
Procedure
To avoid this problem, when re-ordering categories in the
time dimension, decide which aspect of the model is most important:
the order of categories within the time dimension, or the relative
time categories that are included within the time dimension.