Sorting issues with the YTD auto generated categories when incrementally built

[shilpahv]

Sorting issues with the YTD auto generated categories when incrementally built â€"

We are facing the following problem in power play transformer (v7.3):
We have a single date Dim with the following alternate drill down.
TransDate
Year
Month
Day

Drill Down1 - DayOfWeek
Drill Down2 - Year and Week


The level DayOfWeek is a calculation of type text. DayOfWeek = Sun, Mon etc.

1)   With incremental build option enabled: the auto generated category Prior MTD under MTD Grouped is not sorted during the first build. However the second build will sort the categories mentioned above in the correct order.

Could you suggest any solution to sort the categories in the correct order in the first build and with the incremental build option enabled?





Note: we are using an iqd as a source to the transformer and TransDate is of type Date.