Transformer has recently been enhanced to better handle the sorting of merged categories in time-based partitioned cubes. It now supports minor changes to the categories in a cube, from one update to the next, with or without a Unique Move. In most such cases, the sort order of the categories appears as expected when the child member cubes are viewed.
During updates and merges of time-based partitioned cubes, a few assumptions and constraints must be kept in mind:
The changes to categories must be relatively slow and orderly.
There must be no significant changes to the category metadata in the overall model.
An understanding of parent-child and sibling relationships must be available so that Transformer can use that to help build the member cubes.
Under certain circumstances, a unique move may affect the sorting or ordering of categories, in unexpected ways.
For allocation to work properly, you must select the Always Include option for the affected categories.